Formula Request for Phone Number Formatting

[claybwagner28]

Hello,
I received a list of phoje numbers from a vendor in the following format: +1 (615) 555-5555. I would like to convert the phone numbers to 615-555-5555, removing the +1,(), and spaces.
I tried using SUBSTITUTE but I can't quite get it correct.
Any help would be appreciated.
Thanks!
Clay

 

[Fluff]

How about

-.xlsm
	A	B
5	+1 (615) 555-5555	615-555-5555
Data

Cell Formulas
Range	Formula
B5	B5	=SUBSTITUTE(REPLACE(A5,1,FIND("(",A5),""),") ","-")

 

[JvdV]

Book1
	A	B
1	+1 (615) 555-5555	615-555-5555
Sheet7

Cell Formulas
Range	Formula
B1	B1	=TEXTJOIN("-",,DROP(TEXTSPLIT(A1,{"(";") "}),,1))

 

[claybwagner28]

How about

-.xlsm
	A	B
5	+1 (615) 555-5555	615-555-5555
Data

Cell Formulas
Range	Formula
B5	B5	=SUBSTITUTE(REPLACE(A5,1,FIND("(",A5),""),") ","-")

Awesome thanks!

 

[claybwagner28]

Book1
	A	B
1	+1 (615) 555-5555	615-555-5555
Sheet7

Cell Formulas
Range	Formula
B1	B1	=TEXTJOIN("-",,DROP(TEXTSPLIT(A1,{"(";") "}),,1))

Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.