Jewells0905
New Member
- Joined
- Mar 10, 2024
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
- MacOS
I need to join Columns A, B and C together and preface them with +44 to format the phone numbers correctly. They should also have a "." in between, - "+##.###.###.####" -
I am able to get the +44 and the phone numbers in the correct order with formula =JOIN(A2,"+44",B2,C2. However, I am not able to figure out how to get the "." in there. This is also in googlesheets.
I am able to get the +44 and the phone numbers in the correct order with formula =JOIN(A2,"+44",B2,C2. However, I am not able to figure out how to get the "." in there. This is also in googlesheets.
| Area code | Carrier code | Line number | Phone number |
| 439 | 735 | 9116 | +444397354399116 |
| 414 | 623 | 7001 | +444146234147001 |
| 970 | 449 | 5701 | +449704499705701 |
| 759 | 326 | 4030 | +447593267594030 |
