Why does a "false" value return from a cell that is visually blank. This only seems to happen in row 9. If I test the column with an ISBLANK the result is false but the "false" action is only taken in some cells. Puzzeling?
Thanks for any insight or suggestions.
Steve
Newark, DE
Steve
There are spaces in A8.
If posting code please use code tags, see here.
It should be blank but when I examine that cell with an ISBLANK formula the result is FALSE indicating that something is there.
Steve
Steve
The cell has spaces, the formula is checking for "", an empty string.
Graphic_1.jpg
I did check it with the =IF(A1,"","00") and it inserts "00" when A8 appears to be blabk (empty).
look at the position of the cursor when the cell is selected there is a space/spaces
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It appears blank but it isn't, there are spaces in the cell.
Try this in an empty cell.
Formula:
Please Login or Register to view this content.
If A8 was blank/empty this would return 0.
Hey, we're getting close. When I double click on the offending cell the cursor blinks at position 2 in the cell. There is definitely something there however it's invisible. Double clicking on a non-offending cell places the cursor in position 1.
Actually there appears to be two invisible characters in the cell.
Could they perhaps be spaces?
Norie, Using the LEN command the result is 000-00-0001 for the offending cell. Blank cells show 000-00-0000.
Steve
That means there is one character in the cell.
I've just checked the ASCII values of what's in A8 and it's 2 spaces.
Norie,
Thanks! That explains it. Now to find out how two blanks got there.
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks