This function will test if a value is text and return TRUE if it is text and FALSE if it’s not.

 

Syntax

 

ISTEXT(Value)

  • Value (required) – This is the value you want to test if it’s text.

 

Example

 

In this example we test a few values. Notice that even though a value can contain numbers the result is still text.

=ISTEXT(A2)

ISTEXT ISTEXT function