Un-concatenate

[Guest]

I have a column that has a list of firstnames and surnames in it.

Any idea how I split this out into a single column of first name and a
single column of surnames?

Thanks!

 

[CLR]

I have a column that has a list of firstnames and surnames in it.

Any idea how I split this out into a single column of first name and a
single column of surnames?

Thanks!

 

[CLR]

A

 

[CLR]

Sorry Guys, my IE had a brain-f**t.............

I was trying to tell the OP that we need a sample, like do the names have a
space between them, or comma and/or are there any initials,
etc...........sample data needed.....please just type out a few lines, do
not attach a Workbook............tks

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Hi,

Yes, there is a space between the firstname and the surname....

joe smith
james hamilton
sue jones


Thanks!

 

[CLR]

First, save your data and use a copy for this..........make sure there is an
empty column immediately to the right of the column with the
names............then

Highlight the column containing the names, then Data > TextToColumns >
Delimited > Next > select SPACE as the Delimiter > Finish....

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Works perfectly - thanks CLR


James

First, save your data and use a copy for this..........make sure there is an
empty column immediately to the right of the column with the
names............then

Highlight the column containing the names, then Data > TextToColumns >
Delimited > Next > select SPACE as the Delimiter > Finish....

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

You're quite welcome.............thanks for the feedback.........

Vaya con Dios,
Chuck, CABGx3