Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Standard formatting for phone numbers

Topic Labels: Formulas
Solved
Jump to Solution
11491 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Richard
5 - Automation Enthusiast
5 - Automation Enthusiast

My phone number field has rows with different formatting.

e.g.
12824673737

and
(510) 890-9699

How can I force all the phone numbers to be of one format: namely, a 10 digit number without any punctuation in between

10 Replies 10
NoahWBR
4 - Data Explorer
4 - Data Explorer

I’ve dealt with the same issue before, and standardizing phone numbers can be frustrating, especially when formats vary. One approach is to use a simple script or an Excel formula to strip out any non-numeric characters.

Also, if you’re working with phone numbers for verifications or registrations, using a temporary number can be a great option. I’ve found services that let you receive SMS online UK really helpful in situations where you need a clean, standardized number format without formatting inconsistencies. Definitely worth checking out!