How many way to represent the blank space?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
Another one is ISBLANK(Reference)

What do you want to achieve?

--
HTH

Kassie

Replace xxx with hotmail
 
Just a note on ISBLANK()

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

If this post helps click Yes
 
Exactly. That's why I asked what Eric is trying to achieve!

--
HTH

Kassie

Replace xxx with hotmail
 
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.

:)
 
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
 
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
 
I would use " " rather than "". Note the blank between the quotes. That's
what makes it blank, rather than null.

Regards,
Fred.
 
Back
Top