Forum Discussion

MICROSOFTHELP's avatar
MICROSOFTHELP
Copper Contributor
Apr 25, 2020
Solved

ISTEXT Function detecting empty spaces as text?

Hello, I have three cells; and two of these are dependent on the antecedent cell to work.

 

This is an example below - the  actual function is more complicated but the error is no different. 

 

We have three cells here; the first cell contains the ordinary text 'HELLO' on cell F103. The second cell G103, contains the formula =IF(ISTEXT(F103),"HEY", ""), which means that if F103 contains any text, it will display 'HEY', otherwise BLANK. So far so good. We then have cell H103, which functions in the exact same way, =IF(ISTEXT(G103),"HEY NOW", ""), if H103 contains any text, it will display HEY NOW, otherwise, Blank. Now here is the problem.

 

As you can see, despite the fact that reference cell G103 is blank, because F103 is blank, H103 is not blank. It becomes blank if I delete the formula from G103, or if I change G103 to a number, but not if it's changed dependent on F103. 

 

Why is this the case, and how to correct for this? 

Cheers 🙂 

 

(you might see some smaller columns there, ignore, as it doesn't influence anything -- my format is slightly different every so often) 

  • MICROSOFTHELP 

    Anything between double quotes is text. And ISTEXT() detects correctly.

    You may check instead for the length of G103 or for G103<>"".

     

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    MICROSOFTHELP 

    Anything between double quotes is text. And ISTEXT() detects correctly.

    You may check instead for the length of G103 or for G103<>"".

     

Resources