Hey everyone!

I have an XL spreadsheet with tens of thousands of phone numbers, all
entered in different ways. IE

COLUMN A - PHONE NUMBER
973-555-1234
(973) 454-1291
none
(456) 555-3241
283 228 0293
home-(973) 555-1223

See - people entered data all different ways. I can't control the data
entry. But what I need to do is find a way to reformat the results so all
the numbers look like this: (###) ###-####

Can anyone help? Thanks so much!