splitting first and surnames
 

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

splitting first and surnames
 

On Wed, 5 Apr 2006 04:03:01 -0700, mattguerilla
wrote:

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

splitting first and surnames
 

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

Vaya con Dios,
Chuck, CABGx3



"mattguerilla" wrote:

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