IsNonTex

In Excel, the IsNonText function can be used to check for a value that is not text.
The syntax for the IsNonText function is:

IsNonText( value )

value is the value that you want to test. If value is not text, this function will return TRUE. Otherwise, it will return FALSE.

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=IsNonText(A1)	would return FALSE
=IsNonText(A2)	would return TRUE
=IsNonText(A3)	would return TRUE
=IsNonText(A4)	would return FALSE
=IsNonText("hello")	would return FALSE