Quick Navigation

ISNONTEXT Function

Excel 2007+

Summary

The ISNONTEXT function determines if a value is anything other than text, returning TRUE for numbers, dates, logical values, errors, or blank cells. It's essential for data validation and conditional logic that requires distinguishing non-text content from text strings.

Syntax

ISNONTEXT(value)

Parameters

Parameter	Type	Required	Description
value	`Any`	Yes	Value to check - can be a number, text, logical value, error, blank cell, or reference

Using the ISNONTEXT Function

ISNONTEXT is perfect for cleaning imported data, validating user inputs, and creating conditional formulas that behave differently based on data types. Use it to filter out text entries or process only numeric/logical content.

Common ISNONTEXT Examples

Basic Text vs Non-Text Check

=ISNONTEXT(A1)

Returns TRUE if A1 contains a number, date, TRUE/FALSE, error, or is blank; FALSE only if it contains text.

Filter Numbers Only

=IF(ISNONTEXT(A1),A1*2,"Text")

Multiplies numbers by 2, shows 'Text' for text entries.

Data Cleaning Helper

=IF(ISNONTEXT(B2),"Valid","Clean Text")

Flags non-text values as 'Valid' during data import review.

Frequently Asked Questions

Yes, blank cells return TRUE because they are not text.

They are opposites: ISNONTEXT returns TRUE when ISTEXT returns FALSE, and vice versa.

Yes, all error types (#N/A, #VALUE!, #REF!, etc.) return TRUE.

Common Errors and Solutions

Unexpected FALSE result

Cause: Value contains text even if it looks like a number

Solution: Check if numbers are stored as text using ISTEXT or VALUE function

Formula ignores quoted numbers

Cause: Numbers in double quotes like "123" are treated as text

Solution: Use VALUE("123") to convert text numbers to actual numbers

Notes

Numbers in double quotes like "123" return FALSE (treated as text)
Dates, times, and formulas return TRUE
Array formulas and dynamic arrays work correctly
Essential for preprocessing data before mathematical operations

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+