Join a country code and a phone number

Turn 1 and 2015550123 into +12015550123, ready for dialing abroad.

What you'll make

In Excel: 1 + 2015550123 becomes +12015550123.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1OR(A8="",B8="")Checks if the code or the number is empty.No, both are filled
2"Review country/number pair"Shown when the code or the number is missing.Not used for row 8
3"+"&A8A plus sign, then the country code."+1"
4&B8Adds the number right after the code."+12015550123"
5IF( … )Uses part 2 if part 1 finds a gap, else parts 3 and 4."+12015550123"

Read it left to right. The numbers here are made-up.

=IF(OR(A8="",B8=""),"Review country/number pair","+"&A8&B8)

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste country codes and phone numbers into the green columns of the Template tab. The full numbers fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Paste numbers without dashes, a + or the 0 dialed only at home. The formula joins them as they are.