Site icon ExcelNotes

How to Check a Value is not Text

The ISNONTEXT Function is to check whether a value is not text. When the value is not text, the result returns TRUE.

Formula:

=ISNONTEXT(value)

Explanations:

Value is required, the result returns TRUE when the value is not text and returns False when it is text.

Example:

=ISNONTEXT(A3)

Cell A3 is a logical value, not TEXT, so ISNONTEXT(A3) returns TRUE.

=ISNONTEXT(A4)

Cell A4 is "6F", a text value, so ISNONTEXT(A4) returns False.

Download ISNONTEXT Function

Exit mobile version