ISNONTEXT in Excel: Separate Nontext From Valid Numbers
Use Excel ISNONTEXT on blanks, errors and logical values, then distinguish nontext detection from numeric data validation.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =ISNONTEXT(A2) is TRUE for a value that is not text. That includes a genuinely empty cell, so TRUE is much broader than “this is a usable number.”
Availability and version history
- Introduced: first introduction version is not established by the official history reviewed; the current product list is not a launch record.
- Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel Web App.
- Checked: October 14, 2026; official ISNONTEXT reference. Documentation and independently modeled examples; no native Excel execution or broader platform certification.
Syntax and a common validation mistake
=ISNONTEXT(value)
The required value can come from a cell, formula or literal. Microsoft explicitly includes blank cells in TRUE results and says IS tests do not convert quoted numbers. Use this function to classify text versus nontext, rather than to approve every nontext value for arithmetic.
Example 1: inspect a mixed input field
Enter this test column in A2:A9. The formulas create the actual types, rather than strings describing those types.
| Cell | Entry | Expected ISNONTEXT result |
|---|---|---|
| A2 | number 18 |
TRUE |
| A3 | ="18" |
FALSE |
| A4 | =FALSE() |
TRUE |
| A5 | leave empty | TRUE |
| A6 | ="" |
FALSE |
| A7 | =NA() |
TRUE |
| A8 | ="Pending" |
FALSE |
| A9 | number 0 |
TRUE |
Fill =ISNONTEXT(A2) down column B. There are five TRUE results. Only A2 and A9 contain numbers, however. A4 is a Boolean, A5 is empty and A7 is an actual error.
The empty-string result in A6 counts as text even though it looks blank. Conversely, the visible #N/A display in A7 is an error value, not a text string. If you instead entered ="#N/A", the result would be FALSE because that expression creates text.
Example 2: a classification report with explicit priorities
In C2 use this formula and fill down:
=IF(ISTEXT(A2),"Text",IF(ISNUMBER(A2),"Number",IF(ISBLANK(A2),"Empty",IF(ISLOGICAL(A2),"Logical","Other"))))
Expected labels are Number, Text, Logical, Empty, Text, Other, Text, Number. Each test answers its own question. The report deliberately labels the error row “Other”; use ISERROR for a dedicated error category if your report needs one.
This report also shows why replacing ISNUMBER with ISNONTEXT would be wrong: the broad nontext test would swallow the logical, empty and error categories before their specific tests were reached.
Example 3: validate nonnegative numeric quantities
Suppose only numbers greater than or equal to zero are allowed. Use:
=IF(ISNUMBER(A2),A2>=0,FALSE)
For the dataset above, only A2 and A9 pass. Text "18" does not pass until an explicit, appropriate conversion is performed. Add a test such as A2=TRUNC(A2) if fractional quantities are forbidden; ISNONTEXT by itself cannot impose that rule.
A negative control is useful: put -4 in D2. =ISNONTEXT(D2) remains TRUE because -4 is not text, but =IF(ISNUMBER(D2),D2>=0,FALSE) is FALSE. The difference is a business constraint, not a disagreement about the stored type.
Example 4: prove the complement on ordinary scalar values
For each A2:A9 cell compare:
=ISNONTEXT(A2)
=NOT(ISTEXT(A2))
The two Boolean results agree for all eight listed controls. This equivalence explains the name, but it does not add numeric validation. Keep an independently named ISNUMBER helper when downstream formulas require numbers.
Troubleshooting
An unexpectedly TRUE result for a blank cell is documented behavior. An unexpectedly FALSE result for digits often means the input is stored as text. Do not fix an import by converting every field: identifier codes can legitimately require text and leading zeros.
The scalar examples do not certify compound data types, external links or every array-evaluation context. Related guides cover ISTEXT, ISNUMBER and ISBLANK.
References and verification
The datasets are fictional. Expected results follow the cited rules and independent arithmetic or type models; they are not native application captures. Examples use English function names and comma argument separators.