Formulas and Functions
Modifying this control will update this page automatically

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.

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.

See alsoISDATEISNUMBER
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.