Need to replace characters in excel (replace and remove some characters)
I have a 5000 line ling excel document. In column "AG" I have a long list of phone numbers. I need to remove the "-" from the numbers. E.g. 555-555-5555 needs to become 5555555555 all down the column. Similarly, I have column "J" which has birth dates. I need to remove the / from the birthdates and replace them with dashes. E.g. 5/5/1980 needs to be 5-5-1980.
Is there a way to do this without going through all 5000 lines? Please let me know if there is!
Thank you so much.
Microsoft Legacy OSMicrosoft ExcelMicrosoft Office