ISNONTEXT Function - Excel
Overview
The ISNONTEXT function in Excel is a useful tool for checking if a specified value is not a text (string) data type. This function returns a TRUE value if the specified value is not text and returns a FALSE value if it is text.
Example:
=ISNONTEXT(5)
Syntax:
=ISNONTEXT(value)
value: This is the value or reference to the cell or expression you want to check for being non-text.
TRUE Example
In this example, the ISNONTEXT function returns the TRUE value result because C2 equals 5 and that is not a text data type.
FALSE Example
In this example, the ISNONTEXT function returns the FALSE value result because C2 equals ”Apple” and that is a text data type.
