| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split cell | Excel Discussion (Misc queries) | |||
| split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
| Split cell help! | Excel Discussion (Misc queries) | |||
| How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
| Is there a way I can split last name first name in one cell | Excel Discussion (Misc queries) | |||
Linear Mode
