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.




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



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


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

Download ISNONTEXT Function

Leave a Reply