Convert the phone numbers from the current format "### ### ####" to the full format "1-(###)-###-####"

[Jewells0905]

I am trying to convert the phone numbers from the current format "### ### ####" to the full format "1-(###)-###-####" in two steps:

• In column B, I need to just add parentheses around the area code.
• In column C, I am finalizing the new phone numbers.

This is being done in google sheets

this is what I have currently came up with, which is clearly not what I'm trying to achieve. Below are the formulas I'm using
B2 - ="("&LEFT(A2,3)
C2- =")"& RIGHT(A2,9)

Original	Step 1	Step 2
439 735 9116	(439	) 735 9116
414 623 7001
970 449 5701
759 326 4030

 

[Cubist]

In one step... Try:

="1-("& LEFT(A1,3) & ")" & "-" & MID(A1,5,3) &"-"& RIGHT(A1,4)

 

[Jewells0905]

You're a genius! Thank you so much! that worked perfectly!