Un-concatenate
 

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!

We would need a "James Hamilton"
wrote in message ...
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!

A
"James Hamilton" wrote in message
...
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!

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


"CLR" wrote in message
...
A
"James Hamilton" wrote in
message
...
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!

Hi,

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

joe smith
james hamilton
sue jones


Thanks!


"CLR" wrote:

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


"CLR" wrote in message
...
A
"James Hamilton" wrote in
message
...
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!

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


"James Hamilton" wrote in message
...
Hi,

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

joe smith
james hamilton
sue jones


Thanks!


"CLR" wrote:

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


"CLR" wrote in message
...
A
"James Hamilton" wrote in
message
...
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!

Works perfectly - thanks CLR


James

"CLR" wrote:

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


"James Hamilton" wrote in message
...
Hi,

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

joe smith
james hamilton
sue jones


Thanks!


"CLR" wrote:

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


"CLR" wrote in message
...
A
"James Hamilton" wrote in
message
...
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!

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

Vaya con Dios,
Chuck, CABGx3



"James Hamilton" wrote in message
...
Works perfectly - thanks CLR


James

"CLR" wrote:

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


"James Hamilton" wrote in
message
...
Hi,

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

joe smith
james hamilton
sue jones


Thanks!


"CLR" wrote:

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


"CLR" wrote in message
...
A
"James Hamilton" wrote
in
message
...
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!