How to Format Phone Numbers in Excel
A phone column pasted from three different systems is a mess of dashes, brackets, spaces, and missing country codes. Formats and formulas both struggle. Here's how to get to one clean style.
Last updated: August 2026
| Messy input | E.164 | |
|---|---|---|
| (415) 555-1234 | → | +14155551234 |
| 415.555.1234 | → | +14155551234 |
| 0044 20 7946 0000 | → | +442079460000 |
Why formats and formulas struggle
A custom phone format only lines up when every value already has the same number of digits — real lists never do. And a formula approach means stacking SUBSTITUTE to strip (), spaces, and dashes, then TEXT to re-pad, then logic to add a country code only where it's missing. It works until the first entry that doesn't fit, then quietly produces garbage.
The 1-click way — Tellsheet
Normalize Phone Numbers cleans a whole column to one canonical form: international E.164 (+14155551234) or digits only. Set a default country code (US, UK, India, UAE, Bahrain, Saudi, Australia, Germany, …) that's added only to numbers missing one. It writes clean text so the + and leading digits are preserved, leaves anything that isn't a phone number untouched, previews first, and runs entirely on your computer — no numbers are sent anywhere. Pairs with Clean and Remove Duplicates (consistent numbers make dedupe actually work).
Frequently asked questions
How do I make all phone numbers the same format?
Strip punctuation, add the country code where missing, re-format — hard with formulas. Normalize Phone Numbers does it in one click to E.164 or digits-only.
What is E.164?
The international standard: +, country code, national number, no punctuation — e.g. +14155551234. Most CRMs and SMS tools expect it.
Why do my numbers lose the leading zero or +?
Excel treats them as numbers and drops both. Store them as text; Normalize Phone Numbers writes clean text values that keep the + and digits.
Is my data uploaded anywhere?
No. Normalize Phone Numbers runs locally in the add-in; nothing leaves your computer.
Related Excel guides
Standardize phone numbers in one click
Normalize Phone Numbers brings a messy column to E.164 or digits-only — right inside Excel, nothing uploaded.
Get Tellsheet free See pricing