# ISTEXT function in Excel

> ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return.

Source: https://spreadsheetpractice.com/functions/istext · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return.
- **Syntax:** `=ISTEXT(value)`
- **Most common use:** `=SUMPRODUCT(--ISTEXT(B2:B6))` returns 2 (Two ages were entered as text)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the value is text. FALSE for numbers, dates, blank cells, logical values and errors.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return. Use it to find entries like "forty" or "sick" in a column that should hold numbers, before they skew an average.

## Syntax

`=ISTEXT(value)`

| Argument | Required? | What it is |
|---|---|---|
| `value` | Required | The value or cell to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=SUMPRODUCT(--ISTEXT(B2:B6))` | 2 | Two ages were entered as text |
| E2 | `=IF(ISTEXT(B3),"Fix entry",B3)` | Fix entry | "forty" is text, so the row is flagged |
| F2 | `=AVERAGE(B2:B6)` | 34 | AVERAGE skips the text, so it averages only three of five ages |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Respondent | Age |  | Text entries | Row 3 status | Average age |
| 2 | R-101 | 34 |  | 2 | Fix entry | 34 |
| 3 | R-102 | forty |  |  |  |  |
| 4 | R-103 | 27 |  |  |  |  |
| 5 | R-104 | 29 |  |  |  |  |
| 6 | R-105 | 41 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| TRUE for a number | The number is stored as text, such as the "29" above. VALUE(B5) converts it. |
| TRUE for a cell that looks empty | The cell holds a formula that returns "", which counts as text. Test =B2<>"" first if those should be skipped. |

## Tips

- Highlight text in a numbers column with conditional formatting: =ISTEXT($B2).

## Related functions

- [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber): ISNUMBER returns TRUE when a value is a real number, which includes dates and times.
- [ISBLANK](https://spreadsheetpractice.com/functions/isblank): ISBLANK returns TRUE when a cell is completely empty.
- [VALUE](https://spreadsheetpractice.com/functions/value): VALUE converts text that looks like a number into a real number Excel can add, average and compare.

## Questions

### How do I check if a cell contains text?

=ISTEXT(A2). It is TRUE for any text, including digits stored as text, and FALSE for empty cells.

### How do I count cells that contain text?

=SUMPRODUCT(--ISTEXT(A2:A50)) counts them, including numbers that were stored as text.

## Practice

A graded ISTEXT exercise ("Payable hours") is on [the ISTEXT page](https://spreadsheetpractice.com/functions/istext). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
