Functions
ISTEXT
True if value is text
Try it
When to use it
When should I use ISTEXT?
Use ISTEXT to test whether a cell holds text rather than a number, often inside an IF to validate that an entry is a label and not a value.
Does ISTEXT return TRUE for a number?
No — ISTEXT returns FALSE for numbers and TRUE only for text, so it pairs well with ISNUMBER to classify mixed data.
Use cases
A number is not text
Check a single character is text
Used in
Syntax
ISTEXT(value)