The function ISTEXT checks whether a value in a cell is text or not, and returns “TRUE” if the value is text or “FALSE” if not.

Syntax:

=ISTEXT(Cell reference)

Cell reference. Is the cell address that wanted to be evaluated