How to use Excel ISNONTEXT Function – An introduction

Excel ISNONTEXT Function is a logical operator and returns TRUE or FALSE as a result. This function returns TRUE for values like – date, number, time, etc. and returns FALSE for all text values. Excel ISNONTEXT is a member of IS group of functions in Microsoft Excel.

Why we use this?


This function test a cell value for text or non-text.


The syntax for ISNONTEXT


=ISNONTEXT (value)


Parameters or Arguments


Value (required) – this function checks cell value for text or non-text

What it returns as a result?


This function is a logical function and always returns TRUE or FALSE as results.


Important note:

This function returns TRUE for blank cell and formulas returns a non-text result.




Using Date, Time and Number with Excel ISNONTEXT Function


Excel ISNONTEXT Function


In the above image, the “Data” column containing cell values like  – date, number, time, blank cell or text value. Use these values with ISNONTEXT Function in a value field. See result and explanation in the next columns.


Excel ISNONTEXT Function with Error Values


Excel ISNONTEXT Function


Here are are some error messages, which occurs by typing mistakes or missing values in the data table. If these errors return a non-text result, Excel ISNONTEXT Function returns TRUE using these error as value.


Related post

ISREF Function  

ISERROR Function 

ISTEXT Function


Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.