ISTEXT (is text?)

<< Click to Display Table of Contents >>

ISTEXT (is text?)

Syntax:

ISTEXT(Value)

Description:

Returns TRUE if the specified value is text.

Example:

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

ISTEXT(A1) returns TRUE

ISTEXT(C7) returns FALSE

Note:

ISNONTEXT is the counterpart of this function: It returns TRUE if there is no text string in the cell.

See also:

ISNONTEXT, ISLOGICAL, ISNUMBER, ISREF