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

ArgumentRequired?What it does
valueYesThe value, cell or formula to check.

Examples

Example 1 — Anything but text

Only the text entry returns FALSE.

B2fx=ISNONTEXT(A2)
AB
1ValueNon-text?
242TRUE
3TRUE
4TRUETRUE
5PendingFALSE
=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

Kyle Stott

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.