Thread: LEN = 0; ISBLANK = FALSE
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default LEN = 0; ISBLANK = FALSE
An empty string ="" has a length of zero, but the cell is not blank.
--
David Biddulph

"Dave F" wrote in message
...
LEN(C20) = 0
ISBLANK(C20) = FALSE

How could this be?

This would seem a contradiction in terms.


Reply With QuoteReply With Quote