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 check whether cell B2 (Value 2 in column B) holds text (note that a blank cell is not text).
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(B2)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.