How to Import Phone Numbers and its Phone Extensions
How to import phone numbers and their extensions. The phone number and its extension must be in the same field. If it is not, a good program to append the phone number and extension is Microsoft Excel. Also, to have our system parse the extension into a separate field use this code in front of the extension( .x).
Microsoft Excel Concatenate Instructions:
1. Create 2 extra colums: Insert -> Columns
2. In one column use the MS Excel concatenate to append the phone number and its extension together.
For example: If phone is in column a1 and its extension is in column b1 then enter this code in c1:
=concatenate(a1," .x",b1)
3. Copy and paste or drag this code to all the cells in column c.
4. Copy and use Paste Special to copy the values to the new column d.
5. Save the file in CSV format and import the file with the new phone numbers.
In the system the phone number and its extension will be placed in separate fields, respectively.
Attached is a MS Excel spreadsheet titled: "Concatenate_Phone_Example.csv" with an example code and data.
