Formulas and Functions
ISTEXT
The ISTEXT function returns the boolean value TRUE if the given expression evaluates to a string; otherwise it returns the boolean value FALSE.
ISTEXT(cell)
cell: The value to test. If the value can’t be interpreted as a single value, ISTEXT returns an error.
Examples |
|---|
If the table cell A1 contains a string ("Hello") and cell B1 contains a number (100): =ISTEXT(A1) returns TRUE. =ISTEXT(B1) returns FALSE. |