Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Kenny,
You need to separate out the last name. Highlight the column with the names. Go to Data Text to Columns... The Delimited file type should be selected. Click Next. Choose Space as the Delimiter and then click Next. Click Finish and then click OK to replace contents of destination cells. This will work as long as all name entries have a space bewteen the first initial and the last name. Cheers. -- Ken Hudson "Kenny Dee" wrote: Sorry but we don't have a seperated columns for the first and last name, but is there away to sort by last name. such as: D. Jurgens R. Moreno F. Coley D. Baird ???? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |