<< Click to Display Table of Contents >> ISNONTEXT (is no text?)

Syntax:

ISNONTEXT(Cell)

Description:

This returns TRUE if the given cell does not contain text.

Example:

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

ISNONTEXT(A1) returns FALSE

ISNONTEXT(C7) returns TRUE

Additional info:

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

See also:

ISTEXT, ISLOGICAL, ISNUMBER