Originally Posted by psili

find a text editor with regular expressions, then do a search and replace to something like:

find: (.*);(.*)
-- where ";" is the separator
replace \2;\1

Excel, you could do something like:

paste everything in column "a".
hilight column a, then go to "data" -> text to columns -> delimited and then choose your delimeter
in like column g you could combine back the values:
in column g: =concatenate(c1 & ";" & b1)
then use the fill down function in the g column.

dream weaver, many html editors, have regex expression handling to do this for you.