Convert phone numbers

The video below shows the older Phonenumber_Converter sheet. If your workbook has Phonenumber_Validator and a Format & Validate button, use the phone number validator guide instead.

Video walkthrough #

Using the older converter #

1. Paste the phone numbers into the Input column, one per row.
2. If the numbers do not include a country code, select their country and set Append Country Code to Numbers? to TRUE. If they already include the country code, use FALSE to avoid adding it twice. Process different countries separately when adding a code.
3. Click Convert Numbers.
4. Check the Output column before copying it into your message list. Remove extensions and correct any unwanted leading digits yourself.

This older tool removes non-digit characters and can add a country code. It does not establish whether a number is valid or can receive messages.