I am being provided a roster of employees in an excel format, and I am trying to clean-up the formatting of the phone number field. Some of the entries come in as all data (4025551919, 4025550010) and some come in with varying degrees of formating (402-555/0101 or 402/555-1010 and others).
Is their an easy way to start in cell J1 and strip only the numeric character out and place them in the same order in cell M1. Then move to cell J2 and strip out only the numeric characters and place them in cell M2, continuing on until the entire column is completed?
Any help is appreciated.