ISBLANK() does not identify blank cell

  • Thread starter Thread starter Eric_NY
  • Start date Start date
E

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?
 
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!!
 
Back
Top