Format Numbers For Upload To Textburst
Here’s a quick tutorial on how to format mobile numbers in excel, ready to upload into Textburst.
To upload mobile numbers into Textburstwe need to get them into full international format, like this: 447123456789 for a UK number.
Beware, Excel can be misleading:
The most important thing to be aware of is that Excel can be misleading with its number formats. You may think the number below looks like a perfect mobile number:
But with Excel the leading Zero often only exists in “text” format i.e. once you change the cell format to “number” (right click that cell and change to number format), you see what’s really hiding there, a number without a leading zero, as below:
If you upload from either version of the above file the result will be a list of numbers without a leading zero and starting with 7 (the international dialling code for Russia).
Add the International Dialling Code
- Using the concatenate formula in excel you can add 44 (or the relevant international dialling code) to the start of your number:
- Once you have this formula working, copy it down through column B for your complete list of numbers.
- Next step is to copy the newly formatted numbers and do a ‘paste special’ to ‘value only’ to change them from the formula to true ‘numbers’.
- All you have to do now is delete column A and voila, you have a list of mobile numbers that are perfectly formatted and ready for uploading into Textburst.