Overview
☝️Please note that in this article we use +49, Germany's country code, as placeholder. Any other country code can be treated exactly the same way.
Phone number starts with 0 / 0049 / 1 / 49
| A | B | C | D |
1 | First name | Last name | Phone number ❌ | Phone number ✅ |
2 | Maurizio | Superchat | 0156784321001 | +49156784321001 |
3 | Oliver | Superchat | 0049156784321002 | +49156784321002 |
4 | Inka | Superchat | 156784321003 | +49156784321003 |
5 | Juri | Superchat | 49156784321004 | +49156784321004 |
To ensure that your contacts are imported into Superchat with the correctly formatted phone numbers, you need to format them in Excel/Google Sheets.
If the phone numbers are formatted in one of the formats from column C, you can change them to the correct format using the following formula: In this case, we are changing the format of cell C6, which you will need to adjust depending on the row.
=IFS(LEFT(C6,4)="0049",SUBSTITUTE(C6,"0049","+49",1),LEFT(C6,2)="01",SUBSTITUTE(C6,"0","+49",1),LEFT(C6,1)="1","+49"&C6,LEFT(C6,2)="49","+"&C6)
Phone number contains characters
| A | B | C | D |
1 | First Name | Last Name | Phone Number ❌ | Phone Number ✅ |
2 | Maurizio | Superchat | +49 15678 4321001 | +49156784321001 |
3 | Oliver | Superchat | +4915678/4321002 | +49156784321002 |
4 | Inka | Superchat | +49AA156784321003 | +49156784321003 |
In this case, you don't need to do anything further, all characters will be ignored during upload. The important thing is that the number starts with +49.
First name & last name separation
| A | B | C |
1 | Name ❌ | First Name ✅ | Last Name ✅ |
2 | Maurizio Blötscher | Maurizio | Blötscher |
3 | Oliver Klötzer | Oliver | Klötzer |
4 | Inka Seidel | Inka | Seidel |
Assuming your Google Sheets file is set up as above:
A2 = Column with the full name
B2 = Empty column for the first name
C2 = Empty column for the last name
To format the first name, follow these steps:
Insert the following formula into B2:
=LEFT(A2,SEARCH(" ",A2))Now the first name from A2 should be displayed in the correct format in B2
If you then want to format the last name, follow these steps:
Insert the following formula into C2:
=RIGHT(A2,LEN(A2)-LEN(B2))Now the last name from A2 should be displayed in the correct format in C2