Excel Remove Numbers From Cells and Keep Text Easily

How-to basics · Updated November 19, 2026

Yes. In Microsoft Excel for Microsoft 365, put the text in A2 and use =IF(A2="","",LET(txt,A2,chars,MID(txt,SEQUENCE(LEN(txt)),1),TEXTJOIN("",TRUE,IF(ISNUMBER(IFERROR(FIND(chars,"0123456789"),0)),"",chars)))) in another cell to remove digits 0–9 while keeping the remaining characters. For example, Order 47B-2026 becomes Order B-.

How the formula removes digits

The formula examines the source one character at a time. SEQUENCE(LEN(txt)) supplies a position for each character, and MID returns the character at each position. FIND checks whether that character appears in the string 0123456789. If it does, the formula substitutes an empty string; otherwise, it keeps the character. Finally, TEXTJOIN combines the kept characters without adding separators.

The outer IF returns a blank when A2 is blank. Without that check, an empty source could cause the sequence calculation to produce an error. The formula uses LET to give the source text and character array short names, which makes the expression easier to follow and avoids repeating calculations.

This formula uses dynamic-array functions available in Microsoft 365 and Excel 2021 or later. Enter it normally with Enter; you do not need Ctrl+Shift+Enter. It returns a result in the formula cell and leaves the source cell unchanged.

What stays in the cell

Removing numbers does not mean keeping only letters. The formula removes the ten standard digits, 0 through 9, and preserves every other character it encounters. That includes spaces, punctuation, symbols, and letters. For instance, Room 12 / West becomes Room / West, with the original two spaces around the removed digits left in place. If you want to tidy spaces too, that is a separate cleanup step.

Here are other examples of the same rule:

  • SKU-A19-blue becomes SKU-A-blue.
  • 2026 Report (Draft 3) becomes Report (Draft ).
  • +1 (212) 555-0100 becomes + () –.

Those results may look odd when digits are essential parts of an identifier or phone number. Decide what should count as a number before applying a cleanup to important data. This formula is appropriate when the goal is specifically to delete digit characters, not to interpret or preserve meaningful numeric information.

Apply the formula to a column

Use a helper column so the original entries remain available for checking. If your source text is in A2:A100, enter the formula in B2, then copy it down through the corresponding rows. You can drag the fill handle at the lower-right corner of B2, or copy B2 and paste into the remaining cells. Excel adjusts the reference from A2 to A3, A4, and so on.

  1. Insert a blank column beside the source data, or choose another empty column for results.
  2. Enter the formula in the first result row, making sure its source reference points to the matching row.
  3. Fill the formula down and inspect a few results, including rows with punctuation, blanks, and unusual characters.
  4. If the cleaned text should replace the originals, copy the results and use Paste Values in the destination cells. Keep a backup until you have verified the replacement.

Formula results recalculate when the source changes. Pasting values turns those results into fixed text, so later edits to the original column will not update the cleaned column. Keep formulas if you want a live transformation; use values if you need a one-time cleanup or a static export.

Option for older Excel versions

If your Excel version does not support LET and SEQUENCE, nested SUBSTITUTE functions can remove each digit in turn. With the original text in A2, enter this formula in a helper cell:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"0",""),"1",""),"2",""),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9","")

This method works in older Excel releases because SUBSTITUTE is a long-standing worksheet function. Each layer removes one specific digit, leaving other characters untouched. It is less convenient to edit or audit than the modern formula, but it avoids dynamic-array functions and does not require array entry. The cell layout is the same: A2 holds the source, and the formula goes in a separate result cell.

For a single small group of cells, another manual option is to use Find and Replace ten times, once for each digit. On Windows, open Replace with Ctrl+H or use Home > Find & Select > Replace. Enter one digit in Find what, leave Replace with empty, and choose Replace All; repeat for 0 through 9. This changes the selected or searched data directly, so make a copy first. Find and Replace does not treat 0–9 as a digit pattern in ordinary wildcard searches.

Numbers stored as values versus text

The formula is designed to clean text that contains digits, such as product codes or labels. A cell that contains a numeric value is different from text that happens to include numbers. For example, a cell holding the number 123 contains no letters to preserve, so removing its digits leaves an empty result. A value formatted to look like text may still be stored as a number, which affects how Excel processes it.

Dates and formatted numbers deserve particular care. Excel stores dates as serial numbers, and a formula reading a date cell works with its underlying value rather than necessarily reproducing the date as it appears on screen. Currency symbols, leading zeros, and custom number formats can also be display formatting rather than characters in the stored value. If the characters you want to clean are what you see in a formatted cell, first consider converting a copy to text or creating a text representation with the required format, then apply the removal formula to that text.

Text digits outside the standard characters 0–9 are another exception. The formula searches for those ten characters specifically, so other numeral characters, such as some Arabic-Indic digits, are not removed. If your data uses another writing system or contains special digit symbols, the search string must be adapted to include the characters you intend to delete.

Common issues and useful adjustments

  • Extra spaces remain: spaces are not digits, so the formula intentionally preserves them. If you want to remove leading and trailing spaces from the result, wrap the cleanup expression in TRIM. TRIM also reduces repeated ordinary spaces between words to single spaces, which may or may not be desirable.
  • Punctuation remains: hyphens, parentheses, decimal points, and slashes are preserved. That is expected because they are not in the digit list. Decide separately whether punctuation should be deleted.
  • The formula shows an error: check that the formula was entered in a version with LET and SEQUENCE, that parentheses and quotation marks are intact, and that your Excel regional settings use commas as argument separators. Some regional settings require semicolons instead of commas.
  • Only part of a column changes: make sure the formula has been filled through every source row and that each row points to the correct source cell. Structured Excel tables can fill formulas down automatically when a formula is entered in a table column.

A common misconception is that deleting digits also deletes the spaces around them or returns only alphabetic letters. Neither is true here: the formula removes only the specified digit characters. If the desired output is “letters only,” define which alphabet and symbols are allowed, then use a method built for that exact rule rather than assuming digit removal has the same effect.

Choose a safe cleanup method

Use the formula when you need repeatable results, want to preserve the original data, or expect to process many rows. The helper-column approach makes it easy to compare input and output and to adjust the rule later. Use the nested SUBSTITUTE version when compatibility with older Excel is more important than formula brevity.

Use Find and Replace for a small, controlled, one-time edit where changing the original cells is intentional. It can be quick, but it is easy to alter more data than intended if the selection is wrong. Filtering or selecting only the relevant range first, saving a copy, and checking a few results reduces that risk. For a large or business-critical list, keep the source column and validate the cleaned values before replacing or exporting anything.

Frequently Asked Questions

Can I remove numbers from a cell without changing the original?

Yes. Put the formula in a different cell and refer to the source cell. The formula returns a separate result, so the original stays as it was. Copy the output and paste values over the source only if you later decide that replacement is appropriate.

Does the formula remove spaces along with numbers?

No. It preserves spaces exactly as they occur. If removing digits leaves awkward spacing, use a separate trimming or space-cleanup step, and check the output because trimming can change repeated spaces that may be intentional.

Can I keep only letters and remove digits and punctuation?

Not with this formula as written. It removes only 0–9 and keeps punctuation and symbols. Keeping letters alone requires a different character rule, and “letters” can include accented characters or letters from non-Latin alphabets, so define the required set before choosing a solution.

Why did a date or currency value produce an unexpected result?

Excel may store the cell as a numeric value and show a formatted version on screen. A formula may process the underlying value rather than the visible date or currency characters. Convert a copy to an explicitly formatted text representation if the displayed characters are what you need to clean.

Will this work in Excel for the web or on a Mac?

The formula uses Microsoft 365 functions and works in current Excel for the web and Excel for Mac when those functions are available. Interface details and keyboard shortcuts can differ, but the worksheet formula itself does not require a Windows-only command. Older Excel versions can use the nested SUBSTITUTE alternative.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.