S
s2m via OfficeKB.com
WHAT'S THE DIFFERENCE BETWEEN
=" "
=""
<>""
<> " "
=" "
=""
<>""
<> " "
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
= means Is equal to
<> means Is unequal to
"" means Empty
" " means a space
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| WHAT'S THE DIFFERENCE BETWEEN
|
| =" "
| =""
| <>""
| <> " "
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200608/1
|
<> means Is unequal to
"" means Empty
" " means a space
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| WHAT'S THE DIFFERENCE BETWEEN
|
| =" "
| =""
| <>""
| <> " "
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200608/1
|
B
bigwheel
" " is a space, "" is null (nothing) if you enter a space in a cell, CODE(A1)
will return the value 32 whereas you get an error if the cell is blank. When
sorting, any cell with text prfixed with a space will sort lower in rank than
a cell without the space. So " zoo" will appear before "aardvark"
will return the value 32 whereas you get an error if the cell is blank. When
sorting, any cell with text prfixed with a space will sort lower in rank than
a cell without the space. So " zoo" will appear before "aardvark"
G
Gord Dibben
=" " = a spaceWHAT'S THE DIFFERENCE BETWEEN
="" = blank
<>"" not equal blank
<> " " not equal a space
Gord Dibben MS Excel MVP