I have a data set that is populated for me with people who have opted out of receiving text messages. When I export this data set into excel it automatically places a 1 before the phone number.

Example - 15555555555

What I need is to remove the 1 before the phone number AND be able to reformat into (555) 555-5555

I have tried =right(A1,len(A1)-1) which removes the 1 and leaves me with the 9 digits I need BUT I can't seem to then format into (555) 555-5555.

Any ideas?