
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 22, 2019 06:29 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2025 04:35 AM
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!

- « Previous
-
- 1
- 2
- Next »