How to use ISTEXT Function in Excel

The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

Syntax:= ISTEXT (value)

The ISTEXT function syntax has the following arguments:

  • Value (required argument) – This is the given value or expression that we wish to test. The value argument can be a blank (i.e., an empty cell), an error, a logical value, a text, a  number, a reference value, or a name referring to any of these.

Example: Let’s look at some Excel ISTEXT function examples and explore how to use the ISTEXT function as a worksheet function in Microsoft Excel:

ISTEXT Function - How to use ISTEXT Function in Excel

Syntax:  =ISTEXT(A2)

Result:

ISTEXT Function in Excel - How to use ISTEXT Function in Excel

Based on the Excel spreadsheet above, the following ISTEXT examples would return:

Syntax: =ISTEXT(A3)
Result: TRUE

Syntax: =ISTEXT(A4)
Result: FALSE

Syntax: =ISTEXT(A5)
Result: FALSE

Syntax: =ISTEXT(A6)
Result: FALSE

Syntax: =ISTEXT(A7)
Result: FALSE

Syntax: =ISTEXT(A8)
Result: TRUE

Syntax: =ISTEXT(A9)
Result: FALSE

Note:

  1. The ISTEXT function is available in MS Excel 2000 and later versions.
  2. The function will return FALSE even for formula errors such as #VALUE!, #NULL!, etc.
  3. ISTEXT belongs to the IS family. We can use an IS function to get information about a value before performing a calculation or other action on it.
READ:  How to use ISERR Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *