First and Last Name Split in a cell

K

Karla B

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
 
E

Eduardo

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
 
J

Jarek Kujawa

one way:
Johnny Walker in A1

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

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

Karla B

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

Karla B

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

Jarek Kujawa

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to Split First and Last Names 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
VBA Multiple Line handling with Split() 1
Access to split First and Last name 0
First, Last occurance of date in column 5
Split one cell in the middle and fill each with one color 8
help with formula for last input in column 6
First Name & Last Name 2

Top