How do I split a column of information into two?

[Nigel]

I have a column of information that I would like to split into two columns.
As follows

Mr John Smith ([email protected])
Mrs Katie Brown ([email protected])

I need to put everything in the bracket into a new column!

Can anyone help?

 

[Max]

One way, assuming data as posted in A2 down
In B2: =LEFT(A2,SEARCH("(",A2)-1)
In C2: =RIGHT(A2,LEN(A2)-SEARCH("(",A2)+1)
Select B2:C2, copy down as far as required

 

[JoJoDunn]

You could try this - it seemed to work for me...
Highlight the column
Click Data, Text to Column, Delimited, Select Other and put in bracket
symbol ie (
Then Finish
To get rid of the other end bracket ) - highlight the new column and do the
same with the ) symbol and it seems to disappear.
You may need to insert extra column so you don't overwrite another.
Remember - save spreadsheet before attempting!
Hope it helps