Excel ISNONTEXT Function

HomeExcel FunctionsExcel ISNONTEXT Function (Example + Sample File)

What is EXCEL ISNONTEXT FUNCTION

The Excel ISNONTEXT Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if the value supplied (or the value in the cell referred) is a non-text value. With non-text means, means a number, date, a symbol, etc.

How to use it

To learn how to use the ISNONTEXT function in Excel, you need to understand its syntax and arguments:

Syntax

ISNONTEXT(value)

Arguments

  • value: A cell or a value that you want to test.

Notes

  • If a number is enclosed in double quotation marks will be treated as text and formula will return FALSE.

Example

To master the ISNONTEXT function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used it with IF to deliver a message to the user if a non-text value will enter into the cell.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.