The ISTEXT function can help us to test if a cell contains a text value or not.

When a cell contains a text value, it will return TRUE, and FALSE when contains other value or empty.

Syntax:

=ISTEXT (value)

So we can use ISTEXT function to check if a cell contains a text value. By the way, the numeric value entered as text will also turn TURE.