Hello Team,
I have this below data in one cloumn.
Cloumn A
119WATER:FYI0333
120MATTER:BYT0444
144CAUSE:PRI0345
I would like to split this data into the two column
such as
Cloumn A
119WATER
120MATTER
144CAUSE
Column B
FYI0333
BYT0444
PRI0345
Please advise me on this
Thanks in Advance
Cheers...