Home » Excel-Built-In-Functions » Excel-Isnontext-Function

The Excel ISNONTEXT function tests if an initial supplied value is text. If not, the function returns TRUE; If the supplied value is text, the function returns FALSE.

The format of the function is :

Where the Value argument can be supplied as a direct value, or can be a formula or cell reference.

Examples

The spreadsheets below show examples of the Excel Isnontext function. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results :