Originally Posted by Paul Eggleton
Can you live with them in two seperate cells? if so, highlight all the cells then Data, Text to Columns, delimited, tick the comma box, finish.
What he said - works a treat. But just to add you could combine them again after seperating and switching the columns around if you need - concatenate