Making a cell appear blank

[JohnnyTightlips]

Folks,

A recent post talked about treating a cell as blank (i.e. not 0) from a graph point of view. It got me to thinking whether you can have Excel treat a cell containing a formula as blank. Typically I use "" to make it appear blank, but Excel doesn't treat it as such. i.e. =isblank(cell) would return FALSE.

Does such a formula/method exist?

 

[sunnyland]

Hello,

Try:

=len(a1)=0

will return true if blank or empty