The Excel ISTEXT Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Istext-Function Search this site: Custom Search

Related Functions:  ISERROR Function ISLOGICAL Function ISNUMBER Function ISREF Function

Basic Description

The Excel Istext function tests if a supplied value is text, and if so, returns TRUE; Otherwise, the function returns FALSE.

The syntax of the function is:

Where the supplied 'value' argument can be supplied directly, or can be a value returned from a formula, or a reference to a cell containing a value.

Istext Function Examples

The spreadsheets below show several examples of the Excel Istext function. The spreadsheet on the left shows the formulas used, and the spreadsheet on the right shows the results: