How do I use ISTEXT in Excel?
Use ISTEXT when you want to check whether a value is text. Enter Value in that order, then add optional arguments when needed.
Excel Function
ISTEXT
Checks whether value is text.
ISTEXT(value)Arguments
value
RequiredSpecify a single cell reference.
Practice Preview
Use ISTEXT to return the result with these settings (Value: C2 (cell C2 (Value 3 in column C))).
Example Table
| # | AValue 1 | BValue 2 | CValue 3 | DResult |
|---|---|---|---|---|
| 2 | 120 | Text | ||
| 3 | 98.5 | 100 | ||
| 4 | 0 | N/A | ||
| 5 | 45 | Test | ||
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=ISTEXT(C2)Result
TRUE
Practice This Function
ISTEXT FAQ
Where can I practice ISTEXT?
Use the "Start Function Practice" button to jump straight into ISTEXT drills.
What arguments does ISTEXT use?
The main arguments are Value. Enter them in order.