Custard3413
New Member
- Joined
- Aug 18, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- MacOS
- Mobile
- Web
Help me merge these please?
Template:
My Database:
The problem lies in the phone number. The phone number comes in with Country code+area code. Someone please write a formula for merging these two files. THANKS!
Template:
First Name | Last Name | Email* | Mobile Phone* | Country | Block Communication | Employee Email | Contact Tag 1 |
Example: John | Example: Doe | Required Example: johndoe@yahoo.com | Required Example: (123) 456-7890 (Only if Email column is blank) | Example: US (Select from the dropdown) | Example: YES (Select YES to opt-out from any communication) Default: NO | Example: johndoe@yahoo.com | Use this column to associate tags to contacts. Please change the column name with the tag group name you would like to create, and add tags as values. Also make sure, these tags are added under Manage tags option. You can add multiple new columns. |
My Database:
Name | Last Name | Phone | (Nam) e | Country | Block Communication | Employee Email | Contact tag 1 | |
Sonti Lim | Mjshichew@yahoo.com | (1657) 456-3126 | US | adam@diamondsolarinc.com | ||||
Michael D Merle | michaelmerle@hotmail.com | (1626) 515-6204 | US | adam@diamondsolarinc.com |
The problem lies in the phone number. The phone number comes in with Country code+area code. Someone please write a formula for merging these two files. THANKS!