MS Excel: IsNonText Function
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