Summary

ISTEXT returns TRUE when a value is text. That includes words, labels, text-formatted numbers, and empty strings like "".

It returns FALSE for real numbers, dates, logical values, errors, and truly blank cells. That difference is what makes it useful in data cleanup and lookup troubleshooting.

Syntax

=ISTEXT(value)

You can test a cell reference, a typed value, or a formula result.

Arguments

• value - [required] The value you want to test.

ISTEXT vs Other Functions

Using ISTEXT

This function is useful when a field is supposed to hold text and you want to enforce that, or when a value should not be text and you need to catch formatting problems. One common example is numbers stored as text, which can quietly break lookups and math.

The empty-string case is worth remembering. A formula result of "" still counts as text here, even though the cell can look empty on screen.

Example 1 - Check a normal text value

This is the basic use.

=ISTEXT(A1)

Example 2 - Confirm a blank cell is not text

A truly empty cell returns FALSE.

=ISTEXT(B2)

Example 3 - Catch the empty-string case

An empty string still counts as text.

=ISTEXT("") // Returns TRUE.

Example 4 - Find a text-formatted number

This is a common lookup and import issue.

=ISTEXT(C3)

Conclusion Recap

• Main job: ISTEXT checks whether a value is text.
• Important nuance: "" counts as text.
• Blank cells: Truly blank cells return FALSE.
• Good use: Catch text-formatted numbers and text-only fields.