Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
I have a column that has last name and first name, how can i separate them so
that only the last name shows up or vice verse that the first name shows up. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
Hi,
Assuming they are seperated by a space try this. First name =TRIM(LEFT(A1,FIND(" ",A1,1))) Last name =TRIM(MID(A1,FIND(" ",A1,1),LEN(A1))) Mike "naja" wrote: I have a column that has last name and first name, how can i separate them so that only the last name shows up or vice verse that the first name shows up. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
Hi,
Select the names and choose Data, Text to Columns, Delimited, click Next, check Space, click Next, in the Preview area pick the column you don't want and then click the Skip option. -- Cheers, Shane Devenshire "naja" wrote: I have a column that has last name and first name, how can i separate them so that only the last name shows up or vice verse that the first name shows up. thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
Perfect! it worked. Thanks
"naja" wrote: I have a column that has last name and first name, how can i separate them so that only the last name shows up or vice verse that the first name shows up. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate help | Excel Worksheet Functions | |||
Concatenate | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
concatenate | Excel Worksheet Functions | |||
concatenate | Excel Worksheet Functions |