Summary
ISNONTEXT returns TRUE when a value is anything except text. That includes numbers, logical values, errors, and even blank cells.
Because of that, this function is broader than it first sounds. It is not a “number check.” It is a “not text” check, which is a bigger category.
ISNONTEXT is useful when the workbook needs to separate text labels from everything else. That can help in validation and cleanup work, especially when a column is supposed to hold descriptive text but may also contain blanks, numbers, or unexpected formulas.
Purpose
Returns TRUE for anything that is not stored as text.
Return Value
TRUE means non-text. FALSE means text.
Syntax
=ISNONTEXT(value)You can pass a cell, a formula result, or a typed value.
Arguments
- value - [required] The value you want to test.
ISNONTEXT vs Other Functions
| Function | Main job | Result for blank cell |
|---|---|---|
ISNONTEXT |
Checks for anything except text | TRUE |
ISTEXT |
Checks for text | FALSE |
ISNUMBER |
Checks for numbers only | FALSE |
ISBLANK |
Checks for true emptiness | TRUE |
Using ISNONTEXT
This function is helpful when text is the problem you want to screen out. For example, if a column should stay numeric or blank, ISNONTEXT gives you one quick check instead of combining several others.
The main thing to remember is that blank cells return TRUE here. So do logical values and errors. If that sounds too broad for your case, use a more specific function like ISNUMBER or ISBLANK instead.
Example 1 - Check a number
A number is non-text, so the result is TRUE. This shows that ISNONTEXT includes more than just blanks or logical values.
It is a useful starting example because it makes the category clear right away: normal numeric content counts as non-text.
=ISNONTEXT(A1)In cell D2, check whether the value is not text.
Example 2 - Check a blank cell
This returns TRUE too, which is the nuance most people need to remember. A blank cell is not text, so ISNONTEXT includes it in the TRUE side.
This is important because many users expect blank cells to behave differently. The example makes that broad behavior easier to remember.
=ISNONTEXT(B2)In cell D3, check whether a blank cell counts as non-text.
Example 3 - Check a logical value
TRUE and FALSE are not text, so they return TRUE here. That shows the function is checking only whether the value is text, not what kind of non-text value it is.
This helps explain why ISNONTEXT can be too broad for some tasks. It groups numbers, blanks, and logical values together on the same side.
=ISNONTEXT(TRUE)In cell D4, check whether a logical value counts as non-text.
Example 4 - Reject an empty string
An empty string is still text, so the result is FALSE. Even though it can look blank in the cell, Excel still treats "" as text.
This example is useful because it shows the difference between a truly blank cell and a formula that returns an empty string. They may look the same, but ISNONTEXT treats them differently.
=ISNONTEXT("") // Returns FALSE.In cell D5, check whether an empty string counts as non-text.
Conclusion Recap
ISNONTEXT is useful when you need to know whether something is anything except text. In this lesson, that included numbers, blanks, logical values, and the reminder that an empty string still counts as text.
It is a good fit for validation rules where text should be treated differently from everything else. Just remember that the result is broad, so blanks and errors are included too.
- Main job:
ISNONTEXTreturns TRUE for anything that is not text. - Includes blanks: Blank cells count as non-text here.
- Also includes: Numbers, logical values, and errors.
- Use a narrower check: If you only want numbers or only want blanks.
Tell your friends about this post