ISNONTEXT function
ISNONTEXT returns TRUE if a value is anything other than text, and is the opposite of ISTEXT. Blank cells count as non-text, so they return TRUE.
Example
Read it as a sentence: check whether F1 holds anything other than text, which gives TRUE because it is empty.
Excel shows TRUE
F
1
Data
Syntax
ISNONTEXT(value)
-
value(required) - The value to check.
Returns: TRUE for anything that is not 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 |
|---|---|---|
=ISNONTEXT("a") | FALSE | Text |
=ISNONTEXT(1) | TRUE | Number |
=ISNONTEXT(Data!F1) | TRUE | Blank |
=ISNONTEXT(Data!F2) | FALSE | Text number cell |
=ISNONTEXT(Data!F8) | FALSE | Formula "" |
=ISNONTEXT(Data!F5) | TRUE | Error |
=ISNONTEXT(Items!B1:B2) | FALSE | 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
1
Item
2
Boxer cartridge
Items
Watch out for
- Blank cells count as non-text, so they return TRUE.
Where it works
- Excel
- ISNONTEXT 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 .