| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=" " ="" <"" < " "
WHAT'S THE DIFFERENCE BETWEEN
=" " ="" <"" < " " -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200608/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=" " ="" <"" < " "
= means Is equal to
< means Is unequal to "" means Empty " " means a space -- Kind regards, Niek Otten Microsoft MVP - Excel "s2m via OfficeKB.com" <u23063@uwe wrote in message news:6479a5d08a3e2@uwe... | WHAT'S THE DIFFERENCE BETWEEN | | =" " | ="" | <"" | < " " | | -- | Message posted via OfficeKB.com | http://www.officekb.com/Uwe/Forums.a...excel/200608/1 | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=" " ="" <"" < " "
" " 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" "s2m via OfficeKB.com" wrote: WHAT'S THE DIFFERENCE BETWEEN =" " ="" <"" < " " -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200608/1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=" " ="" <"" < " "
On Tue, 08 Aug 2006 19:23:42 GMT, "s2m via OfficeKB.com" <u23063@uwe wrote:
WHAT'S THE DIFFERENCE BETWEEN =" " = a space ="" = blank <"" not equal blank < " " not equal a space Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
