ISBLANK returns flase when there is nothing in the cell referenced

C

cugrngneer

I am using the ISBLANK function before comparing values in cells, so that I
don't get a match when there is no data to compare. Excel is returning a
false (implying that the cell contains data), but nothing appears in the cell
being tested. The data being tested by ISBLANK has come from an extract of an
ACCESS database, if that has any bearing on the outcome.
 
D

dlw

is there a blank space in the cell, try =code(a1) or whatever the cell is
and see if a number comes up, 32=space.
 
C

cugrngneer

thanks for the suggestion. It returns #value. Does that mean that there is
nothing there?
 
D

Dave Peterson

If you have formulas that evaluate to "" (=if(a1>5,"","ok") and convert it to
values (copy|paste special|values), you'll be left with this junk.
 
Top