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.
