Solved: Split string into two columns

[Aussiebear]

I have a list of strings similar to the following that I wish to split into two columns.
89.28.114.111 (Moldova, Republic of)
194.8.75.163 (Switzerland)
194.8.75.163 (Switzerland)
194.8.75.50 (United Kingdom)
94.23.226.25(France)

I wish to split the IP address from the (text)section. Can someone supply the code for this please?

[Bob Phillips]

Do Data>Text To Columns with a se;parator of (.

[Aussiebear]

Thanks Bob.