ISBLANK() does not identify blank cell
 

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() does not identify blank cell
 

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!!
--
Gary''s Student - gsnu200817


"Eric_NY" wrote:

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() does not identify blank cell
 

Those are formula returned "blanks", ie: ""
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Eric_NY" wrote:
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?