I would use " " rather than "". Note the blank between the quotes. That's
what makes it blank, rather than null.

Regards,
Fred.

"Eric" wrote in message
...
Thank everyone very much for suggestions
I would like to assign a blank into cell under specific condition, at this
moment, I assign "", which work for Excel 2003, but when I transfer this
file
into Quick Office for my Nokia, which cannot recognize the symbol "" as a
blank. Therefore, I try to look for another symbol, which is general to be
use as a blank, and Quick Office will work for my file.
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric

"Kassie" wrote:

Exactly. That's why I asked what Eric is trying to achieve!

--
HTH

Kassie

Replace xxx with hotmail


"Jacob Skaria" wrote:

Just a note on ISBLANK()

If there is a formula in the reference cell ISBLANK() returns FALSE.

If this post helps click Yes
---------------
Jacob Skaria


"Kassie" wrote:

Another one is ISBLANK(Reference)

What do you want to achieve?

--
HTH

Kassie

Replace xxx with hotmail


"Eric" wrote:

Does anyone have any suggestions on how many way to represent the
blank space
in Excel?
"" is a blank space.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric