# How to remove numbers from text in Excel

In Excel 365, keep only the characters that aren't digits: =TRIM(LET(c,MID(A2,SEQUENCE(LEN(A2)),1),CONCAT(IF(ISNUMBER(--c),"",c)))).

**Excel:** `=TRIM(LET(c,MID(A2,SEQUENCE(LEN(A2)),1),CONCAT(IF(ISNUMBER(--c),"",c))))` (Microsoft 365 only)

**Google Sheets:** `=TRIM(REGEXREPLACE(A2,"\d",""))`

## Example

Sample data (row 1 is the header):

| A | B |
| --- | --- |
| Raw | Without numbers |
| Aiko123 |  |
| B2B Sales |  |
| Room 4B |  |
| Order#4471 |  |
| Chidi Okafor 2 |  |
| No digits here |  |

Formula in B2, filled to B7: `=TRIM(LET(c,MID(A2,SEQUENCE(LEN(A2)),1),CONCAT(IF(ISNUMBER(--c),"",c))))`

Result: Aiko; BB Sales; Room B; Order#; Chidi Okafor; No digits here

## How it works

LET names `c`, the list of single characters. `--c` turns digits into numbers and everything else into errors, so ISNUMBER is TRUE only for digits. IF swaps those for "", CONCAT joins the rest back together, and TRIM removes the space left by "Chidi Okafor 2".

In Google Sheets, `\d` matches any digit and REGEXREPLACE deletes them all.

## Other ways

- `=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"0",""),"1",""),"2",""),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9",""))`: Works in every version: one SUBSTITUTE per digit.

## Common mistakes

- Removing digits can leave double spaces or a space before punctuation. Keep the TRIM.
- Decimal points and minus signs aren't digits, so "-12.5 kg" becomes "-. kg". Remove those characters too if they belong to the numbers.

## Questions

**How do I keep only the numbers instead?**

Flip the test: `=CONCAT(IFERROR(MID(A2,SEQUENCE(LEN(A2)),1)*1,""))`.

**Is there a REGEXREPLACE in Excel?**

Yes, in Microsoft 365: `=REGEXREPLACE(A2,"[0-9]","")`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/remove-numbers-from-text