Add the +1 code to a phone number

Turn 2015550123 into +12015550123, kept as text.

What you'll make

In Excel: 2015550123 becomes +12015550123.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8=""Checks if the phone cell is empty.No
2"+1"The calling code the US and Canada share."+1"
3A8Adds the ten-digit phone number."+12015550123"
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste ten-digit phone numbers, digits only, into the green column of the Template tab.
  3. 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