Parameter List
Syntax
ISNONTEXT(value)
value
The value to test. For example: 123
, TRUE
, A1
, "Hello"
, or any cell reference or expression.
More details
ISNONTEXT returns TRUE for any value that is not text: numbers, dates, logical values (TRUE/FALSE), error values, and blank cells. It returns FALSE only for text strings. This function is useful for filtering or identifying non-text data in mixed datasets.