Replace a 00 dialing prefix with a plus
Turn 0012015550123 into +12015550123, and flag numbers that don't start with 00.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LEFT(A8,2)="00" | Checks that the number starts with 00. | Yes |
| 2 | "+"&MID(A8,3,99) | Puts + in place of the 00. | "+12015550123" |
| 3 | "Review dialing prefix" | What the cell says for any other number. | Not used for row 8 |
| 4 | IF( … ) | Uses part 2 when part 1 says yes, otherwise part 3. | "+12015550123" |
The result is text, so no digits are lost. The numbers here are made-up.
=IF(LEFT(A8,2)="00","+"&MID(A8,3,99),"Review dialing prefix")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 phone numbers that start with 00 into the green column of the Template tab. The + numbers fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only on a list you know writes 00 before the country code. Paste the numbers as text so the 00 stays.
Microsoft's help: LEFT function
OTHER ROUTES YOU MIGHT LIKE

Restore the lost zero in a phone number
2079460123, width 11 → 02079460123
Get the template →
Remove phone separators, keep the plus
(201) 555-0123 → 2015550123
Get the template →
Remove a leading 1 from 11-digit phones
12015550123 → 2015550123
Get the template →
Hide "Phone:" when there's no phone number
(blank) → no "Phone:" line
Take this route →