Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEN = 0; ISBLANK = FALSE
LEN(C20) = 0
ISBLANK(C20) = FALSE How could this be? This would seem a contradiction in terms. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEN = 0; ISBLANK = FALSE
oh yea do you have a formula in C20? That can cause some problems also.
"Dave F" wrote: LEN(C20) = 0 ISBLANK(C20) = FALSE How could this be? This would seem a contradiction in terms. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEN = 0; ISBLANK = FALSE
If C20 contains:
="" then the length is zero. ISBLANK is FALSE because TRUE is only for truely empty cells. In fact, you have found a way to distinguish an empty cell from a cell with a formula returning "" -- Gary''s Student - gsnu200767 "Dave F" wrote: LEN(C20) = 0 ISBLANK(C20) = FALSE How could this be? This would seem a contradiction in terms. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEN = 0; ISBLANK = FALSE
C20 doesn't contain ="" though.
The data is downloaded from a database. Perhaps there is some hidden character in the cell. When I place the curso in the formula bar and hit backspace then ISBLANK returns TRUE. On Feb 6, 3:57*pm, Gary''s Student wrote: If C20 contains: ="" then the length is zero. *ISBLANK is FALSE because TRUE is only for truely empty cells. In fact, you have found a way to distinguish an empty cell from a cell with a formula returning "" -- Gary''s Student - gsnu200767 "Dave F" wrote: LEN(C20) = 0 ISBLANK(C20) = FALSE How could this be? This would seem a contradiction in terms.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
ISBLANK | Excel Worksheet Functions | |||
IF(ISBLANK) | Excel Worksheet Functions | |||
If(ISBLANK) | Excel Worksheet Functions | |||
C1 appears blank, but ISBLANK(c1) returns false | Excel Worksheet Functions |