First and Last Name Split in a cell
 

I'm trying to split the first and last names in a cell and have it appear it
two seperate cells so I can create some labels.
I've used this function in Excel in the '03 version and I can't seem to find
this formula in the '07 Excel version.
Can someone please help me. I know it was a pretty easy formula.

Thanks,
Karla

First and Last Name Split in a cell
 

Hi Karla,
You can select the column and do, Data, Text to columns and choose the
separator you have between both, maybe a "," or an space. it will do the trick

"Karla B" wrote:

I'm trying to split the first and last names in a cell and have it appear it
two seperate cells so I can create some labels.
I've used this function in Excel in the '03 version and I can't seem to find
this formula in the '07 Excel version.
Can someone please help me. I know it was a pretty easy formula.

Thanks,
Karla

First and Last Name Split in a cell
 

one way:
Johnny Walker in A1

name:
=LEFT(A1,FIND(" ",A1)-1)

surname:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

First and Last Name Split in a cell
 

Thanks, I'll try that. It's still not the formula I'm looking for. If I saw
it I'd remember.

"Eduardo" wrote:

Hi Karla,
You can select the column and do, Data, Text to columns and choose the
separator you have between both, maybe a "," or an space. it will do the trick

"Karla B" wrote:

I'm trying to split the first and last names in a cell and have it appear it
two seperate cells so I can create some labels.
I've used this function in Excel in the '03 version and I can't seem to find
this formula in the '07 Excel version.
Can someone please help me. I know it was a pretty easy formula.

Thanks,
Karla

First and Last Name Split in a cell
 

This I know is not the formula I had used before. This seems kind of
complicated.
Thanks for your help anyhow.

"Jarek Kujawa" wrote:

one way:
Johnny Walker in A1

name:
=LEFT(A1,FIND(" ",A1)-1)

surname:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

First and Last Name Split in a cell
 

=MID(A1,1,FIND(" ",A1)) for name

=MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND(" ",A1)+1) for surname