ISTEXT Function in Excel – Test whether the cell has text values

ISTEXT Function in Excel tests if a supplied value has text. If so the ISTEXT Function returns TRUE, if not the function returns FALSE.

Syntax of ISTEXT Function in Excel:

ISTEXT(value)

Where value argument is the value or expression to be tested.

 

Example of ISTEXT Function in Excel:

Formula

ISTEXT Function in Excel 1

  • The above example takes up simple values, Expressions and cell reference as input and returns TRUE only if the resultant value has text, otherwise the function returns FALSE

Result:

ISTEXT Function in Excel 2

previous-small ISTEXT Function in Excel                                                                                                                 next_small ISTEXT Function in Excel