ISTEXT

Definition: ISTEXT is a function that returns TRUE if a value is text, and FALSE if it is not.

Syntax: =ISTEXT(value)

Situation: This formula is appropriate when you need to check if a value is text.

Example: If you want to check if cell A1 contains text, the formula =ISTEXT(A1) will return TRUE if it contains text, and FALSE if it does not.