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.

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

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.

=ISNONTEXT(A1)

Example 2 - Check a blank cell

This returns TRUE too, which is the nuance most people need to remember.

=ISNONTEXT(B2)

Example 3 - Check a logical value

TRUE and FALSE are not text, so they return TRUE here.

=ISNONTEXT(TRUE)

Example 4 - Reject an empty string

An empty string is still text, so the result is FALSE.

=ISNONTEXT("") // Returns FALSE.

Conclusion Recap

• Main job: ISNONTEXT returns 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.