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:
Syntax: =ISTEXT(A2)
Result:
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:
- The ISTEXT function is available in MS Excel 2000 and later versions.
- The function will return FALSE even for formula errors such as #VALUE!, #NULL!, etc.
- 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.
