Inserting parentheses to a phone number

daveE · Dec 9, 2004

Trying to change
+1 201-963-6572
to
+1(201)963-6572
can anyone help?

JE McGimpsey · Dec 9, 2004

One way:

=SUBSTITUTE(SUBSTITUTE(A1,"-",")",1)," ","(",1)