Add the +1 code to a phone number
Turn 2015550123 into +12015550123, kept as text.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks if the phone cell is empty. | No |
| 2 | "+1" | The calling code the US and Canada share. | "+1" |
| 3 | A8 | Adds the ten-digit phone number. | "+12015550123" |
| 4 | IF( … ) | Leaves empty rows blank, otherwise uses parts 2 and 3. | "+12015550123" |
The result is text, so Excel keeps the + sign. The numbers here are made-up.
=IF(A8="","","+1"&A8)How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own numbers. Paste ten-digit phone numbers, digits only, into the green column of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only for numbers you know are in the US, Canada or another +1 country. Leave extensions out.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Add an extension to a phone number
(201) 555-0123 and 0012 → (201) 555-0123 ext. 0012
Get the template →
Join a country code and a phone number
1 + 2015550123 → +12015550123
Get the template →
Mask all but the last four phone digits
2015550123 → ******0123
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →