LEN = 0; ISBLANK = FALSE
Put a single apostrophe in C20.
Saved from a previous post:
If you want to see what's left in that cell after you convert ="" to values,
try:
Tools|Options|Transition Tab|Toggle Transition Navigation keys on.
Then select one of those cells and look at the formula bar. You'll see an
apostrophe. (Don't forget to toggle the setting to off.)
When I want to clean up this detritus, I do this:
Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all
Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all
Dave F wrote:
LEN(C20) = 0
ISBLANK(C20) = FALSE
How could this be?
This would seem a contradiction in terms.
--
Dave Peterson
|