Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. :) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 "Fernando Fernandes" wrote: 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. :) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many way to represent the blank space?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does blank space appear at end of number? | Excel Discussion (Misc queries) | |||
How to remove blank space? | Charts and Charting in Excel | |||
add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
BLANK SPACE TO A NUMBER | Excel Worksheet Functions | |||
I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) |