Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Standard formatting for phone numbers

Topic Labels: Formulas
Solved
Jump to Solution
11548 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!