ISNONTEXT (is no text?)

<< Click to Display Table of Contents >>

ISNONTEXT (is no text?)

Syntax:

ISNONTEXT(Value)

Description:

Returns TRUE if the specified value is not text.

Example:

If A1 contains a text string, C7 contains a number, then:

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