Outlook export to excel for reformatting telephone numbers

I hope I put the right title to this.

I use Outlook as my contact manager and I want to reformat all my telephone numbers to all look like this (404) 555-1212 or 1 (404) 555-1212.

So my dilemma is how do I tell excel to format the telephones that appear like this 4045551212 or 404-555-1212 to the above?

Thank you!!!

provided they are only in those 2 formats
try

=IF(ISERROR(FIND("-",A1)),"("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4),"("&SUBSTITUTE(A1,"-",") ",1))

Or:

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