ISTEXT

Using the Excel ISTEXT Function

Summary

The Excel ISTEXT function returns TRUE when a cell contains text, and FALSE when it does not. The function can be used to check if a cell contains a text value, or a number entered as text.

Syntax

=ISTEXT (value)

Syntax Breakdown

Value
Required. A value that will be tested to determine if it contains text. This argument is typically supplied as a cell address.


Usage Notes

ISTEXT checks if a cell contains text. If it does, the function returns TRUE and if it does not the function returns FALSE.

ISTEXT is part of a group of Excel functions called IS functions that return the logical values TRUE or FALSE.