ISTEXT Function - Excel
Overview
The ISTEXT function in Excel is a useful tool for checking if a specified value is a text (string) data type. This function will return a TRUE result if the specified value is text and it will return a FALSE result if it is not.
Example:
=ISTEXT("Apple")
Syntax:
=ISTEXT(value)
value: This is the value or reference to the cell or expression you want to check for being text.
TRUE Example
In this example, the ISTEXT function gives us a TRUE value result because C2 equals “Apple” which is a text data type.
FALSE Example
In this example, the ISTEXT function gives us a FALSE value result because C2 equals 1 which is not a text data type.
