Thread: Empty cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_7_] Peter T[_7_] is offline
external usenet poster
 
Posts: 162
Default Empty cell?

"GARYWC" wrote in message
How can I see what cell A1 contains?
It appears empty but =ISBLANK(A1) returns "FALSE"


Maybe the cell contains a zero length sting, try
=IsText(A1)

If that returns true and IsBlank is false just delete it, or maybe also test
for =Len(A1) is zero

Peter T