View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fernando Fernandes Fernando Fernandes is offline
external usenet poster
 
Posts: 6
Default How many way to represent the blank space?

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.

:)