What are the advantages in returning an empty string text cell versus just
leaving it blank?

"JMB" wrote in message
...
empty string. you probably see them mostly in IF statements. Excel won't
display anything on the screen, but it is not the same as entering a zero
value because it has a text format. So you could run into problems if
dependent cells are trying to perform calculations on a cell that returns
(or
could return) an empty string.


"Easydoesit" wrote:

What do the empty set of quotes mean in some of the functions and
formulas
described here?