Sign up for free
Functions

ISNONTEXT

Returns TRUE if the value is not text (i.e., if it's a number, logical value, error, or blank cell), and FALSE if the value is text. This function is the logical opposite of ISTEXT.

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.

Examples

ISNONTEXT() returns 1