The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

**Syntax**:= ISTEXT (value)

The ISTEXT function syntax has the following arguments:

**Value**(required argument) – This is the given value or expression that we wish to test. The value argument can be a blank (i.e., an empty cell), an error, a logical value, a text, a number, a reference value, or a name referring to any of these.

**Example**: Let’s look at some Excel ISTEXT function examples and explore how to use the ISTEXT function as a worksheet function in Microsoft Excel:

**Syntax**: =ISTEXT(A2)

**Result**:

Based on the Excel spreadsheet above, the following ISTEXT examples would return:

**Syntax**: =ISTEXT(A3)**Result**: TRUE

**Syntax**: =ISTEXT(A4)**Result**: FALSE

**Syntax**: =ISTEXT(A5)**Result**: FALSE

**Syntax**: =ISTEXT(A6)**Result**: FALSE

**Syntax**: =ISTEXT(A7)**Result**: FALSE

**Syntax**: =ISTEXT(A8)**Result**: TRUE

**Syntax**: =ISTEXT(A9)**Result**: FALSE

**Note**:

- The ISTEXT function is available in MS Excel 2000 and later versions.
- The function will return FALSE even for formula errors such as #VALUE!, #NULL!, etc.
- ISTEXT belongs to the IS family. We can use an IS function to get information about a value before performing a calculation or other action on it.