Using the Excel ISNONTEXT Function


The Excel ISNONTEXT function will return TRUE when a cell contains a non-text value, such as a number, date, or time. The function also returns TRUE for blank cells and for cells containing formulas that return a non-text result.



Syntax Breakdown

Required. A value that will be tested for non-text values.

Usage Notes

ISNONTEXT checks for non-text values in a cell. If non-text values are found the function returns TRUE.

ISNONTEXT is considered one of Excel's IS functions. These functions are used to test conditions and return TRUE or FALSE.