Clean & Adjust 4000 Rows in Excel

Hello I have a spreadsheet with 4000 rows of Business contacts 2 main things are needed (1) Clean out some unneeded characters in the business open & close hours fields (2) Some businesses open & close 2 or 3 times a day like 9a-12p & then 1p-4p each of such entities will just need to be separated by a comma e.g. 9a-12p, 1p-4p That's all