Excel ISTEXT Function

Logic Function ยท Beginner Level

What is ISTEXT?

Returns TRUE if the value is text. Use for data validation and conditional logic.

Syntax

=ISTEXT(value)

Example

Formula: =ISTEXT(A1)

Result: TRUE or FALSE

How It Works

Returns TRUE if A1 contains text, FALSE for numbers, dates, errors, or blanks. Useful for data validation.

Learn More Excel Functions