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.
Leave a Reply