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

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.

=ISTEXT(value)

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;

Is the order number in A2 stored as text?

	A	B
1	Order no.	Text?
2	A-1042	TRUE

The formula in B2:

=ISTEXT(A2)

Result: TRUE

A-1042 contains a letter and a dash, so Excel keeps it as text and the result is TRUE.

Thinking an empty cell counts as text. ISTEXT returns FALSE for it.
Expecting dates to be text. Excel stores dates as numbers, so a real date gives FALSE.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.