ISTEXT

Checks whether the specified value refers to any item that is text.

Syntax

ISTEXT( Any x ) → Logical

Parameters

x

Required. The value to test.

Remarks

If x is a text value, returns TRUE. If x is a reference to a cell, the value of the referenced cell is tested. Blank cells are not considered texts. If x is an error value, this error value is returned. In any other case, the function returns FALSE.

Example

Formula

=ISTEXT(A1)
=ISTEXT("Value")

See Also

Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERR Function
ISERROR Function
ISNA Function
ISNONTEXT Function
TYPE Function