How do I split a column of information into two?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel - 23 Jan 2008 01:05 GMT

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

Mr John Smith (johnsmith@hotmail.com)
Mrs Katie Brown (katiebrown@hotmail.com)

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

Can anyone help?

Reply to this Message

Max - 23 Jan 2008 09:18 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I have a column of information that I would like to split into two columns.
> As follows
[quoted text clipped - 5 lines]
>
> Can anyone help?

Reply to this Message

JoJoDunn - 23 Jan 2008 21:09 GMT

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

> I have a column of information that I would like to split into two columns.
> As follows
[quoted text clipped - 5 lines]
>
> Can anyone help?

Reply to this Message