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.
Excel shows TRUE
F
1
2
'123
Data
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.
| Formula | Excel shows | Case |
|---|---|---|
=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.
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
6
Hello World
7
0
8
=""
Data
The Items sheet these formulas read
B
C
1
Item
Category
2
Boxer cartridge
Tools
Items
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 .