Summary
ISTEXT returns TRUE when a value is text. That includes words, labels, text-formatted numbers, and empty strings like "".
It returns FALSE for real numbers, dates, logical values, errors, and truly blank cells. That difference is what makes it useful in data cleanup and lookup troubleshooting.
ISTEXT is especially useful in import cleanup and mixed-type columns. It tells the workbook whether a value is truly text, which helps when the next step should only run on labels, notes, or text-based codes instead of numbers or blanks.
Purpose
Returns TRUE only when Excel sees the value as text.
Return Value
TRUE means text. FALSE means not text.
Syntax
=ISTEXT(value)You can test a cell reference, a typed value, or a formula result.
Arguments
- value - [required] The value you want to test.
ISTEXT vs Other Functions
| Function | Main job | Result for "" |
|---|---|---|
ISTEXT |
Checks for text | TRUE |
ISNONTEXT |
Checks for anything except text | FALSE |
ISNUMBER |
Checks for numbers | FALSE |
ISBLANK |
Checks for true emptiness | FALSE |
Using ISTEXT
This function is useful when a field is supposed to hold text and you want to enforce that, or when a value should not be text and you need to catch formatting problems. One common example is numbers stored as text, which can quietly break lookups and math.
The empty-string case is worth remembering. A formula result of "" still counts as text here, even though the cell can look empty on screen.
Example 1 - Check a normal text value
This example checks whether a cell contains text in the normal sense, such as a name, label, or note. It is the direct way to confirm that Excel sees the value as text and not as a number, blank, or date.
That matters when a sheet mixes labels with calculations. Knowing whether a value is text can help you decide whether it belongs in a lookup, a message field, or a cleanup step.
=ISTEXT(A1)In cell D2, check whether the value is text.
Example 2 - Confirm a blank cell is not text
This example separates a real blank cell from text content. If the cell has not been filled at all, ISTEXT returns FALSE because there is no text stored there.
That is useful when you need to tell the difference between missing input and a typed label. A blank cell and a text cell may both look harmless, but they mean different things in a worksheet.
=ISTEXT(B2)In cell D3, check whether a blank cell counts as text.
Example 3 - Catch the empty-string case
This example catches a detail that often surprises beginners. Even though "" can look blank on screen, it is still a text value.
So ISTEXT returns TRUE here. That is important when formulas create empty-looking results and you need to know whether the cell is truly blank or just displaying blank text.
=ISTEXT("") // Returns TRUE.In cell D4, check whether an empty string counts as text.
Example 4 - Find a text-formatted number
This example is useful for imported files where numbers sometimes arrive as text. A value like "500" may look fine, but ISTEXT will reveal that it is still text-formatted.
That makes it easier to spot values that may fail in calculations, sorting, or numeric comparisons until they are converted properly.
=ISTEXT(C3)In cell D5, check whether a number stored as text counts as text.
Conclusion Recap
ISTEXT is useful when you need to know how Excel is storing a value, not just how it looks on the sheet. This lesson showed that normal words, labels, and even numbers stored as text all return TRUE, which makes the function helpful for cleanup and import checks.
The easy part to miss is the difference between a truly blank cell and an empty string. A blank cell returns FALSE here, but "" still counts as text, and that small detail often explains confusing lookup or validation results.
- Main job:
ISTEXTchecks whether a value is text. - Important nuance:
""counts as text. - Blank cells: Truly blank cells return FALSE.
- Good use: Catch text-formatted numbers and text-only fields.
Tell your friends about this post