Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() CW wrote: I recieved a list that contains names listed first name then last name in the same cell. Is there a way to either sort last name first or to convert this to separate the cells? Hi CW, You can split up the names in to two or more cells if you highlight your list. Then go to Data - Text To Colums here Chose Delimited and press next. Chose the delimier your list is using (Might be Space) and press finish. All the names should be split into diffrent cells. Regards, Bondi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Lists... | Excel Discussion (Misc queries) | |||
Lists... | Excel Discussion (Misc queries) | |||
VLOOKUP and Multi Lists | New Users to Excel | |||
Excel - need a function to compare lists | Excel Worksheet Functions |