"Empty "cell is not empty?

[JacobMortensen]

Hi All.

I have a cell where I have used both ws functions and VBA functions to test content.

The cell appears to have no content, but still it is not empty.

VBA:
isemtpty(cell) returns false

WS:
isblank(cell) = FALSE
code(cell) = #VALUE!
istext(cell) = TRUE

I'm in doubt about how to formulate my question, but I wonder, since the cell have no CODE value but ISTEXT is true, then what is the cell?

 

[Special-K99]

Use the following:
Assuming the cell is A1

=LEN(A1) returns 1 if cell is just one character in length.
=CODE(LEFT(A1,1)) should return the ascii value of the 1st character in the cell

If this spreadsheet is web related then the character could well be CHAR(160) which appears as a space but is not.

 

[Jonmo1]

VBA:
isemtpty(cell) returns false

WS:
isblank(cell) = FALSE
code(cell) = #VALUE!
istext(cell) = TRUE

I can reproduce those exact results if the cell is a formula returning ""
Or if the cell 'WAS' a formula returning "", but has since been copied and pasted as values.


Is that the case?


"" is NOT blank/empty.
It's a zero length text string.

The basic Excel Law in play here is that a formula cannot return 'Nothing', it must return 'Something'.
"" is pretty much the closest we can get to having a formula return blank/nothing/empty