ISTEXT

This function tests whether a value, an expression or contents of a referenced cell has text data.

Syntax

ISTEXT(cellreference)

ISTEXT(value)

ISTEXT(expression)

Arguments

[Required] Specify a cell reference, a numeric or text value, or an expression for the argument.

Remarks

Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

• If the data type of the argument is text, this function returns TRUE.

• If the data type of the argument is not text, this function returns FALSE.

• If the argument refers to an empty cell, this function returns FALSE.

Examples

ISTEXT(B3)

ISTEXT(R1C2)

ISTEXT("Total") gives the result TRUE

ISTEXT(12) gives the result FALSE