View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default LEN = 0; ISBLANK = FALSE

Did you import that data or something?

Usually this is caused by a ' indicating that it is supposed to be text. In
this case if there is a ' in it but no data you will get what you received.

Try copying a cell from a blank workbook and pasting it in to C20 to see if
you get a different result.

"Dave F" wrote:

LEN(C20) = 0
ISBLANK(C20) = FALSE

How could this be?

This would seem a contradiction in terms.