tags:

views:

19

answers:

1
Q: 

excel empty string formula

On Excel why putting a formula with the contents

=""

sometimes make the replacement for an empty string and sometimes it places literally that text in the cell.

Note: every cell of the worksheet is in the text format.

A: 

It depends on the order in which you format the cell as text.

If the cell is not formatted as text, your formula will read ="" and the cell will be blank.

If the cell is formatted as text, your formula will read ="" and the cell will read =""

If you had the cell NOT formatted as text (number or general), entered ="" and THEN formatted the cell as text, your formula will read ="" and the cell will be blank.

Michael  2010-07-12 18:47:14

related questions

Does anyone have a good Proper Case algorithm
Converting bool to text in C++
Does PHP have an equivalent to this type of Python string substitution?
PHP ToString() equivalent
What's the difference between a string constant and a string literal?
What would be the fastest way to remove Newlines from a String in C#?
Why is String.Format static?
PowerShell - How do I pass string parameters correctly?
What's the best string concatenation method using C#?
Java: Best way of converting List<Integer> to List<String>
C# String output: format or concat?
Parse usable Street Address, City, State, Zip from a string
C# Save Dialogs
How do I Convert a string to an enum in C#?
PowerShell - how do I do a string replacement in a function?
Case insensitive string comparison in C++
Why doesn't Ruby have a real StringBuffer or StringIO?
Checking for string contents? string Length Vs Empty String
Remove Quotes and Commas from a String in MySQL
Test serialization encoding
In C# what is the difference between String and string
String.indexOf function in C
What is the best way to parse strings in Java
Format string to title case
Generate list of all possible permutations of a string