Phone numbers are frequently used data types. So you would think they would be straightforward to work with, right? Right?

Well if you have phone numbers from multiple people and countries, it gets to be a mess.

You may find yourself having a spreadsheet with a bunch of different phone numbers and you’re stuck figuring out how to clean them.

If you want a quick way to do it, check out Clean Spreadsheets!

However, if you are trying to code or manually clean them yourself here is what you need to keep in mind.

What would cleaning a phone number do?

Cleaning a phone number will allow you to determine whether the number is valid and separate it into its components such as country code, area code and subscriber number. …


Love Spreadsheets

Products and resources that magically simplify hard spreadsheet tasks. Check us out at

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store