Un-concatenate

J

James Hamilton

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!
 
C

CLR

We would need a "James Hamilton said:
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!
Click to expand...
 
C

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
 
J

James Hamilton

Hi,

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

joe smith
james hamilton
sue jones


Thanks!
 
C

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
 
J

James Hamilton

Works perfectly - thanks CLR


James

CLR said:
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
Click to expand...
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top