ISTEXT (is text?)

<< Click to Display Table of Contents >>

ISTEXT (is text?)

Syntax:

ISTEXT(Cell)

Description:

This returns TRUE if the given cell contains text.

Example:

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

ISTEXT(A1) returns TRUE

ISTEXT(C7) returns FALSE

Additional info:

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