Separation of a column

[mircoaccess87]

Dear All,



I need to split the values inside one column in two distinct columns, using semicolon as separator.

For example,

at the beginning I have:
COL1
aaa;xx
bbb
rrr;cc

and I want to get:
COL1 COL2
aaa xx
bbb
rrr cc

Is it possible?

Thanks!!

Mirco.

[mircoaccess87]

The format of the second table probably is not so clear,

under COL1 there are: "aaa", "bbb", "rrr"

and under COL2 there are: "xx" and "cc"