Site icon ExcelNotes

How to Check Whether a Value is Text

ISTEXT Function checks whether a value is a text. The result returns TRUE when it is text, and returns FALSE when it is not.

Formula:

=ISTEXT(value)

Explanations:

Value is required, the result returns TRUE when the value is text and returns False when it is not.

Example:

=ISTEXT(A1)

Cell A1 is a logical value, not text, so ISTEXT(A1) returns False.

=ISTEXT(A4)

Cell A4 is text "a", so ISTEXT(A4) returns True.

Download ISTEXT Function

Exit mobile version