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.
Excel 2007, Excel 2003, Excel XP, Excel 2000
Let's take a look at an example:
Based on the Excel spreadsheet above: