Text
Clean Phone Numbers
Strip all non-numeric characters from phone numbers, removing dashes, parentheses, spaces, and dots. Essential for data normalization and import preparation.
Excel Formula
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," ",""),"-",""),"(",""),")",""),".","" )Google Sheets Version
=REGEXREPLACE(A2,"[^0-9]","")Step-by-Step Explanation
1
Each SUBSTITUTE removes one type of character
2
Removes spaces, dashes, parentheses, and dots
3
Nested SUBSTITUTE calls process the string sequentially
4
Google Sheets alternative: REGEXREPLACE is cleaner
5
Result is digits only: 5551234567
Example
| Raw Phone (A) | Clean Phone (B) |
|---|---|
| (555) 123-4567 | 5551234567 |
| 555.123.4567 | 5551234567 |
| +1-555-123-4567 | 15551234567 |
Result: Formula removes all formatting → 5551234567
Common Variations
Format as (XXX) XXX-XXXX
="("&LEFT(B2,3)&") "&MID(B2,4,3)&"-"&RIGHT(B2,4)Re-format cleaned number
Add country code
=IF(LEN(B2)=10,"1"&B2,B2)Prepend 1 for US numbers
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →