Practice free

ISTEXT function

ISTEXT returns TRUE if a value is text and FALSE otherwise. Empty text and numbers formatted as text both count as text, so they return TRUE.

Example

Read it as a sentence: check whether the value in F2 is text, which gives TRUE.

Practice this in the app

Syntax

ISTEXT(value)

value (required)
The value to check.

Returns: TRUE if the value is text.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ISTEXT("a") TRUE Text
=ISTEXT(1) FALSE Number
=ISTEXT(Data!F2) TRUE Text number cell
=ISTEXT(Data!F8) TRUE Formula ""
=ISTEXT(Data!F1) FALSE Blank
=ISTEXT(Data!F5) FALSE Error
=ISTEXT(Items!B1:C2) TRUE Range spills

The Data sheet these formulas read

A cell that starts with = holds that formula.

The Items sheet these formulas read

Watch out for

  • Empty-looking "" is text.
  • Numbers formatted as text return TRUE.

Where it works

Excel
ISTEXT is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .