Using the Excel ISNONTEXT Function

Summary
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
=ISNONTEXT (Value)Syntax Breakdown
ValueRequired. 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.