|
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.
__________________
Your post count means nothing.
|