Detect text characters

When working with imported content or data from external sources, you often need to filter out junk rows that don’t contain text and keep only those that do.

The simplest way to perform such a filter is to display a Boolean value (TRUE or FALSE) next to each cell — does it contain real text or not?

Find Text Using a Formula

Excel includes a built-in function called ISTEXT, but it’s not always reliable for this use case. It simply checks the formatting of the cell — so even if a cell contains just a space, a number formatted as text, or a punctuation mark, ISTEXT will still return TRUE. If that works for your case, you’re good to go. But most users asking how to detect text in a cell are really looking for actual letters — not formatting.

So, before asking how to detect text, define what you consider to be “text.”

Some users consider only alphabetic characters (letters) to be real text.

If that sounds like you, the following formula will help. It uses the NOT and EXACT functions, with help from LOWER and UPPER, to check for the presence of letters:

=NOT(EXACT(LOWER(A1), UPPER(A1)))

The logic is simple: if the cell content remains the same after converting to both lowercase and uppercase, it likely contains no letters — since LOWER and UPPER only affect letters.

Find Letters and Digits

Other users may consider digits (0–9) to be part of text content as well. Such a set of symbols (letters plus digits) is usually referred to as Alphanumeric letters. Read the article on how to find alphanumeric characters.

Find Specific Text Characters

If you want to detect specific types of characters — for example, only Latin, or only digits — use one of the following dedicated tools:

• Find Latin characters
• Find digits

For more advanced needs, try the “Find cells by regular expression” tool in the same section.

See also:

• Remove Latin characters from Excel
• Remove digits from Excel text
• Extract Latin characters in Excel
• Extract digits from text in Excel