splitting first and surnames

[mattguerilla]

Hi,

If I have a list of names in excel such as
Craig Fox (A1)
John Jones (A2)

etc, how do I get excel to split the names into two columns, such as: -

Craig (B1)
John (B2)
in one column and in the same rows the surnames appear

Fox (C1)
Jones (C2)

I would like to do this to a long list of names

Matt

 

[Ron Rosenfeld]

Hi,

If I have a list of names in excel such as
Craig Fox (A1)
John Jones (A2)

etc, how do I get excel to split the names into two columns, such as: -

Craig (B1)
John (B2)
in one column and in the same rows the surnames appear

Fox (C1)
Jones (C2)

I would like to do this to a long list of names

Matt

If the names are as you show, you could
1. Copy column A to column B
2. Select Column B
3. Use the Data/Text to columns wizard with <space> as the delimiter.

Or you could use formulas

B1: =LEFT(A1,FIND(" ",A1)-1)
C1: =MID(A1,FIND(" ",A1)+1,255)


--ron

 

[CLR]

Highlight the column, then Data > TextToColumns > Delimited > and use space
for the delimiter......

Vaya con Dios,
Chuck, CABGx3