How to clean and reformat telephone numbers in Excel [Infographic]

Topic:

Does your customer database have telephone numbers entered with different formatting? Perhaps some with the +61 country code, some with (0) and some starting with 614. Or do you have mobile phone numbers ending up in the columns for home or office numbers, or vice versa?

If you are nodding your head, we extend our sympathies and warmly welcome you to the club!

We know the pain of having to work with an uneven data set, hence we’ve created this infographic to guide you, step by step, on how to clean and reformat telephone numbers in Excel so that you can have a telephone list that is accurately and consistently formatted.

And even though we create this with our Echo users in mind, it’s useful for any application or platform that needs consistency, so share with anyone who may have the same challenge!

How to use excel to format phone numbers

Author Avatar
Crystal Lam

I'm the Marketing Manager at Esendex Australia, with a background in journalism. I'm passionate about storytelling and the ever-changing world of emerging technologies.