A
Access Joe
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!
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!