How to Use the ISTEXT Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 4 min read · includes 2 free exercises

In short: ISTEXT returns TRUE if a value is text or a reference to a cell containing text. The formula is =ISTEXT(value). It is often paired with IF.

What ISTEXT does

ISTEXT is the counterpart of ISNUMBER: it answers whether a value is text. Use it to find text hiding in a numeric column, or to branch a formula by the type of its input. It is most often paired with IF.

ISTEXT syntax

=ISTEXT(value)

Per Google's help page, it returns TRUE if the value is text or a reference to a cell containing text, and FALSE otherwise. The page adds a detail worth remembering: ISTEXT("") returns TRUE, because an empty string is text, whereas a reference to a blank cell returns FALSE. For truly empty cells, use ISBLANK.

A step-by-step example

Cell A2 holds the word cat and cell A3 holds the number 42.

A
1Value
2cat
342
=ISTEXT(A2)

This returns TRUE. =ISTEXT(A3) returns FALSE, because 42 is a number. The empty string is the surprising case:

=ISTEXT("")

This returns TRUE.

Common mistakes

Try it yourself

Use the cells above (A2 and A3). Type your formula into the box, starting with =, then press Check.

Exercise 1: Is it text?

Write a formula that checks whether the value in A2 is text.

Hint: pass the cell reference.

Exercise 2: The empty string

Write a formula that tests an empty string (two quotation marks with nothing between them) with ISTEXT.

Hint: the argument is "".

What to learn next

Syntax and rules in this guide were checked against Google's ISTEXT help page. See all guides.