How many way to represent the blank space?

[Eric]

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

 

[Kassie]

Another one is ISBLANK(Reference)

What do you want to achieve?

--
HTH

Kassie

Replace xxx with hotmail

 

[Jacob Skaria]

Just a note on ISBLANK()

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

If this post helps click Yes

 

[Kassie]

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

--
HTH

Kassie

Replace xxx with hotmail

 

[Fernando Fernandes]

the ones I know, in the code:

""
Empty
Null

but within Excel (in formulas), the only way I know is "".

you can also create a name and say it means "". And then use the name intead
of the two quotes.

to do it, you type Ctrl+F3
name: Blank (the word blank)
refersto: =""

it should work!

i imagine that maybe you want to be able to replace "" in bunch of formulas
to something, and it would be easier to use a name instead.

 

[Eric]

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

 

[dhstein]

Here is an IsEmpty function which I use for my own purposes - your needs may
be slightly different, but you can easily modify it to check for any
conditions that you would like.

Function IsEmpty(Entry As Range)

IsEmpty = True

If Entry.Value = "" Then Exit Function
If Entry.Value = 0 Then Exit Function
Length = Len(Entry.Value)
If Length = 0 Then Exit Function

If (Length = 1) And (Asc(Entry.Value) = 32) Then Exit Function

IsEmpty = False

End Function

 

[Fred Smith]

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

Regards,
Fred.