This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.
Excel function · Logic
ESTTEXTE(ISTEXT)
Checks whether a cell holds text.
What it does
ISTEXT returns TRUE when a value is text, including numbers stored as text, and FALSE for numbers, dates, empty cells and errors.
Syntax
=ESTTEXTE(value)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;
Arguments
- value
- The cell or value to check.
Example
Is the order number in A2 stored as text?
| A | B | |
|---|---|---|
| 1 | Order no. | Text? |
| 2 | A-1042 | VRAI |
The formula in B2:
=ESTTEXTE(A2)Result: VRAI
A-1042 contains a letter and a dash, so Excel keeps it as text and the result is TRUE.
Common mistakes
- Thinking an empty cell counts as text.
ISTEXTreturns FALSE for it. - Expecting dates to be text. Excel stores dates as numbers, so a real date gives FALSE.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | ISTEXT | , |
| Deutsch | ISTTEXT | ; |
| Français | ESTTEXTE | ; |
| Español (España) | ESTEXTO | ; |
| Español (México) | ESTEXTO | , |
| 日本語 | ISTEXT | , |
| 한국어 | ISTEXT | , |
| 繁體中文 | ISTEXT | , |
| ไทย | ISTEXT | , |
| ខ្មែរ | ISTEXT | , |
| Tiếng Việt | ISTEXT | ; |