How to Check Whether a Value is Text

ISTEXT Function checks whether a value is a text. The result returns TRUE when it is text, and returns FALSE when it is not.




Value is required, the result returns TRUE when the value is text and returns False when it is not.



Cell A1 is a logical value, not text, so ISTEXT(A1) returns False.


Cell A4 is text "a", so ISTEXT(A4) returns True.

Download ISTEXT Function

Leave a Reply