ISTEXT (is text?)

Navigation:  Formulas and functions > Functions from A to Z >

ISTEXT (is text?)

Previous pageReturn to chapter overviewNext page

Syntax:

ISTEXT(Cell)

Description:

This returns TRUE if the specified value is 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:

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