How to Convert an SMS Database to International Format (+27)
Convert South African mobile numbers from local format to international format (+27) using a simple Excel formula before uploading to TouchBasePro SMS.
All numbers loaded to TouchBasePro SMS need to be in international format, which means South African Numbers need to loaded as +27 or 27. However, you may have some numbers loaded as local format (082). Luckily, we have an Excel Formula that'll sort this right out.
Firstly, your database will probably look like this:
It's important to note that your numbers are in Column B, as we'll need this information just now.
In an unused Column, paste the below formula. We've pasted it assuming Column B is your numbers, but if you have them in Column C for example, change the B to a C:
="27"&TEXT(RIGHT(B1;9);0)
We pasted our Formula in Column C - now, at the bottom right of Cell C1 (or wherever you put the formula), click and drag the formula as far down as the last number in your database.
All your numbers should be good to go! However, we're not quite done yet. Even though you see nice, formatted numbers, Excel still thinks those rows are Formulas. Select all the numbers and paste them into the next avaliable column (be sure to align them correctly so that the right number is with the right person!) and, in the paste options, make sure you choose "values".
Do a sanity check on your data (i.e. check that B, C and D are all the same number ultimately) - it's the safe to delete the columns B and C, leaving only the final pasted (with VALUES chosen when pasting) column.
If you already have some numbers in your database as International Format, don't worry, the forumla won't break them, and it's safe to apply the formula to your entire sheet.
If you get stuck, please feel free to send your database to support@touchbasepro.com asking that it be converted to international format. We'll follow this same guide and have it back to you as soon as possible.
Frequently asked questions
- What format do SMS numbers need to be in for TouchBasePro?
- All numbers loaded to TouchBasePro SMS need to be in international format, which means South African numbers must be loaded as +27 or 27.
- What Excel formula do I use to convert local South African numbers to international format?
- Paste this formula into an unused column, adjusting the column letter to match where your numbers are stored: ="27"&TEXT(RIGHT(B1;9);0)
- Will the formula break numbers that are already in international format?
- No. If you already have some numbers in your database in international format, the formula will not break them, and it is safe to apply it to your entire sheet.
- What should I do if I get stuck converting my database?
- Send your database to support@touchbasepro.com asking that it be converted to international format. The support team will follow the same process and return it to you as soon as possible.