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!