Remove phone separators, keep the plus
Turn (201) 555-0123 into 2015550123. A leading + or 0 stays, as text.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The phone number, with brackets, a space and a hyphen. | "(201) 555-0123" |
| 2 | SUBSTITUTE( … "(" … ")" … ) | Takes out both brackets. | "201 555-0123" |
| 3 | SUBSTITUTE( … " " … ) | Takes out every space. | "201555-0123" |
| 4 | SUBSTITUTE( … "-" … ) | Takes out every hyphen. | "2015550123" |
| 5 | SUBSTITUTE( … "." … ) | Takes out every period. A + sign stays. | "2015550123" |
Each bracket wraps the one inside it, so Excel works from the inside out. Part 2 is two brackets, one for ( and one for ). The numbers here are made-up.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A8,"(",""),")","")," ",""),"-",""),".","")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own numbers. Paste phone numbers into the green column of the Template tab. The digits fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Only brackets, spaces, hyphens and periods come out. Look over any result that still has letters or an extension.
Microsoft's help: SUBSTITUTE function
OTHER ROUTES YOU MIGHT LIKE

Remove a leading 1 from 11-digit phones
12015550123 → 2015550123
Get the template →
Get a phone number from a tel link
tel:+12015550123;ext=12 → +12015550123
Get the template →
Read the extension from a tel link
tel:+12015550123;ext=0012 → 0012
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →