Write a phone number as (201) 555-0123

Turn ten digits like 2015550123 into (201) 555-0123. Empty rows stay empty.

What you'll make

In Excel: 2015550123 becomes (201) 555-0123.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8=""Checks whether the cell is empty.No, it has 2015550123
2LEFT(A8,3)Takes the first three digits, the area code."(201) "
3MID(A8,4,3)Takes the next three digits."(201) 555-"
4RIGHT(A8,4)Takes the last four digits."(201) 555-0123"
5IF( … )Leaves an empty cell blank, otherwise writes the label."(201) 555-0123"

Read it left to right. The brackets, space and hyphen are joined in between parts 2, 3 and 4. The numbers here are made-up.

=IF(A8="","","("&LEFT(A8,3)&") "&MID(A8,4,3)&"-"&RIGHT(A8,4))

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 into the green column of the Template tab. The labels fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Paste digits only, with no +1 or extension. The formula doesn't check the count or that the number is in use.

Microsoft's help: LEFT function