ISBLANK() does not identify blank cell

[Eric_NY]

In Excel 2003....

I have some cells which:
- look blank
- TYPE() = 2
- LEN() = 0

But ISBLANK() is FALSE. I can't figure out why.

Any suggestions?

 

[Gary''s Student]

ISBLANK() will only return TRUE is the cell is empty.

If the cell contains:
=""
ISBLANK() will return FALSE

It probably should have been called ISEMPTY()


In fact if A1 contains:
=""
and you copy A1 and paste/special/values into A2, then
=ISBLANK(A2)
will STILL return FALSE!!

 

[Max]

Those are formula returned "blanks", ie: ""
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik