Article updated on February 06, 2018

The ISTEXT function returns TRUE if value is text.

Formula in cell C3:

=ISTEXT(B3)

Excel Function Syntax

ISTEXT(value)

Arguments

value Required. The value you want to check for text.

Comments

The ISTEXT function is very useful to identify error values in arrays. Most Excel functions return the error value, however, this function returns FALSE if it encounters an error.