How do you format international numbers in excel?

UnaroSMS supports UK and international mobile numbers. If you have an international Unaro account you will need to upload all of your numbers (including UK numbers) with the correct country codes in front of them.

If you are a company based in the UK, it is likely that all of your UK numbers start with a 7 or 07, not with a 44 or +44. If this is the case, don’t panic, this simple trick in Excel will get your numbers into international format in no time.

STEP 1: Open your Excel spreadsheet

STEP 2: Make sure that all mobile numbers are running down one column

STEP 3: Click the blank box in the column right of the first number

STEP 4: In this blank box enter =CONCATENATE(44,A1) and hit enter

STEP 5: Grab the corner of this box and drag down throughout all of the numbers going down the original column

STEP 6: This will fill the new column with all of the mobile numbers now including the 44 country code in front of them

STEP 7: Now copy this column and paste over the old column

STEP 8: Save the file in a CSV format and you’re ready to upload your contacts into your international Unaro account.

Request a FREE 30 Day Trial


By submitting this form you confirm that you have read and agree with our Privacy Policy, our Terms & Conditions, and agree to be contacted by Unaro Limited.

Play Video
Play Video

Get Started Today

Get Started Today

Claim Your 30 Day Free Trial Today!

Start Your Free 30 Day Trial Today!