View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tcfowler@gmail.com is offline
external usenet poster
 
Posts: 2
Default Removing parentheses in a phone number

I have a row (M2) of phone number that are mismatched with the
following:

555-555-5555
(555)555-5555
(555) 555-5555
5555555555

I just want to simply have all numbers:

555-555-5555

I have read endless pages in the group but nothing addresses my
issue. I have changed the format to 000-000-0000, but it does not
remove parentheses.