It makes it Text; a String in vba; a Space in the vernacular.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30+ ways to sort)

..
..
..

"Mike"
wrote in message
...
Hi,

Say you have something like this in cell b2: If(a2=5,1," ")

If a2=3, by executing the condition above what does " " make b2?
Blank, Logical, 0, or what? If you want to refer later on to cell b2
you need to know what " " mean, right?

Thanks,
Mike