Navigation:  Formulas and functions > Functions from A to Z > ISNONTEXT (is no text?)

Syntax:

ISNONTEXT(Cell)

Description:

This returns TRUE if the specified value is not text.

Example:

If cell A1 contains a fixed string or a calculation that returns a string, while cell C7 contains a number, the following applies:

ISNONTEXT(A1) returns FALSE

ISNONTEXT(C7) returns TRUE

Note:

ISTEXT is the counterpart of this function: It returns TRUE if the cell contains a text string.

See also:

ISTEXT, ISLOGICAL, ISNUMBER