ExcelBanter - =" " ="" <""

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =" " ="" <"" < " " (https://www.excelbanter.com/excel-discussion-misc-queries/103855-%3D-%3D.html)

s2m via OfficeKB.com

=" " ="" <"" < " "

WHAT'S THE DIFFERENCE BETWEEN

=" "
=""
<""
< " "

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1

Niek Otten

=" " ="" <"" < " "

= 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
|

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"

"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

Gord Dibben

=" " ="" <"" < " "

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

All times are GMT +1. The time now is 11:16 PM.