ISNONTEXT Function
Checks whether a value is anything other than text.
Category
Information
Available in
All versions, Microsoft 365
Returns
TRUE or FALSE
Want to practice ISNONTEXT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ISNONTEXT is the opposite of ISTEXT: TRUE for numbers, dates, logical values, errors and blank cells; FALSE only for text.
Because blanks count as non-text, it's handy when “empty or a number” is acceptable but text is not.
Syntax
=ISNONTEXT(value) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value | Yes | The value, cell or formula to check. |
Examples
Example 1 — Anything but text
Only the text entry returns FALSE.
B2fx=ISNONTEXT(A2)
| A | B | |
|---|---|---|
| 1 | Value | Non-text? |
| 2 | 42 | TRUE |
| 3 | TRUE | |
| 4 | TRUE | TRUE |
| 5 | Pending | FALSE |
=ISNONTEXT(A2) Explain
Common mistakes
- Expecting a blank cell to be FALSE. Blank isn't text, so ISNONTEXT returns TRUE. Combine with ISBLANK if blanks need separate handling.
Notes
- =ISNONTEXT(A2) gives the same answer as =NOT(ISTEXT(A2)).
- Related functions: ISBLANK, ISNUMBER, ISTEXT, ISNONTEXT, ISLOGICAL, ISERROR, ISERR, ISNA, ISFORMULA, ISREF.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.