The function wizard for the IsNonText function:
IsNonText(Value)
Value. Checked value.
It checks if the value is text.
It returns TRUE if the value is not text, otherwise it returns FALSE.
Numbers, empty cells, logical values, text, cell references, and formulas can be used as a parameter value.
Empty cells are not text ones.
| Formula | Result | Description |
| =IsNonText(C2:E9) | TRUE | The C2:E9 cell range does not contain only text values. |
See also:
Function Wizard │ Logical Functions