hi, is there a way to get the data below (which is in one cell) into separate cells going down so it's nice and tidy. At the moment i'm copying the data 5 times and deleting the unwanted text to have one day in each cell: The problem is it's not consistence with the separators. some have a full stop, space, semi colon or space. I want to delete the separators and just be left with the text. Thank you
Monday, Tuesday; Wednesday. Thursday Friday Monday Tuesday Wednesday Thursday Friday |