Excel ISTEXT Function

Using the Excel ISTEXT Function


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.


=ISTEXT (value)

Syntax Breakdown

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.