Jason Morin wrote:
1. Select the column.
2. Go to Data Text to columns
3. Select "Delimited" and select a comma as your
delimiter.
4. Switch the columns around.


And then concatenate, as the OP wants both in the same column!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk