ISTEXT function
ISTEXT returns TRUE if the cell contents refer to text. If an error occurs, the function returns a logical or numeric value.
Syntax
ISTEXT(value)
value is a value, number, Boolean value, or an error value to be tested.
Example
=ISTEXT(D9) returns TRUE.
=ISTEXT(C3) returns FALSE.