FORMULA & SQL / TEXT
Keep only the numbers in text.
Tested, not guessed.
The Excel and Google Sheets formula and the SQL query, each run on the rows below. Open this with your own data ↗
The example rows
| Row | A: Region | B: Rep | C: Amount | D: Order Date | E: Status | F: Customer |
|---|---|---|---|---|---|---|
| 2 | North | Ana | 1,200 | 2026-03-01 | Paid | Jo Smith |
| 3 | South | Ben | 450 | 2026-03-15 | Open | Raj Patel |
| 4 | North | Cy | 300 | 2026-04-02 | Paid | Lee Wong |
| 5 | East | Ana | 980.50 | 2026-04-20 | Paid | Mia Ross |
| 6 | North | Ben | 75 | 2026-05-05 | Open | Jo Smith |
| 7 | West | Dee | 1,640 | 2026-05-18 | Paid | Sam Okoro |
The formula
Excel
=REGEXREPLACE(A2,"[^0-9]","")
REGEXREPLACE(Region (A2), "[^0-9]", blank) — which replaces the parts of text that match a pattern.
REGEXREPLACE needs Google Sheets or a recent Excel 365.
Run on the example rows:
| Row | Result |
|---|---|
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 |
The SQL
PostgreSQL
SELECT *, REGEXP_REPLACE(region, '[^0-9]', '', 'g') AS digits_only FROM sales
Other databases
MySQL
SELECT *, REGEXP_REPLACE(region, '[^0-9]', '') AS digits_only FROM sales
BigQuery
SELECT *, REGEXP_REPLACE(region, r'[^0-9]', '') AS digits_only FROM sales
Snowflake
SELECT *, REGEXP_REPLACE(region, '[^0-9]', '') AS digits_only FROM sales
Your own data
Paste your rows into the free tool and it writes this for your columns, then runs it on your data before you copy it. Open the tool ↗