Phone Number - change format

[KBeglan]

How do I change the format for an existing phone number: 555-555-5555 to be 15555555555? This would be adding "1" and removing "-" (dashes). What formula would I use?

[Fluff13]

Hi & welcome to the board.
How about
=1&substitute(a2,"-","")

[KBeglan]

Thank you! Thank you! Thank you! It worked!!!!!!

[Fluff13]

You're welcome & thanks for the feedback.

[KBeglan]

Ok. One more question.

How do I change the format for an existing phone number, this time with parenthesis (555) 555-5555 to be 15555555555? This would be adding "1" and removing "-" (dashes) and removing parenthesis"()". What formula would I use?

[Fluff13]

How about
=1&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,") ",""),"-",""),"(","")

[KBeglan]

Thank you so much! You're the best!!!

[Fluff13]

Glad to help & thanks for the feedback.