Pretty simple but having problems...
I have a list of about 100 names that have the entire name (First and Last) in each cell. How can I sort the list based on the Lastname rather that the Firstname?
Thanks for the help,
M
Pretty simple but having problems...
I have a list of about 100 names that have the entire name (First and Last) in each cell. How can I sort the list based on the Lastname rather that the Firstname?
Thanks for the help,
M
If the First Name and the Surname are seperated by a space then if you insert a blank column next to your name you can go to Data - Text to Columns - Leave as Delimited and go to next - On the next screen ensure Space is selected (with a tick) - Then click on Next - Then click on Finish
This will split your data into two seperate columns with first name and surname and will allow you to sort using the second column first and then the first name.
Hope this does what you wanted?
Regards
Carl
It's easiest to slipt the column in two and leave it that way, for future sorting ease.
Insert a column to the right of the current column.
To split the column, select it, then under Data select Text to Column.
Select delimited, next, select space (make sure no others are selected), next, select each column and select text, finish.
Try this in the next column and pull down. Sort both columns using the
values in the second column. Delete second column.
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
HTH
Regards,
Howard
"mmednick" <[email protected]> wrote in
message news:[email protected]...
>
> Pretty simple but having problems...
>
> I have a list of about 100 names that have the entire name (First and
> Last) in each cell. How can I sort the list based on the Lastname
> rather that the Firstname?
>
> Thanks for the help,
>
> M
>
>
> --
> mmednick
> ------------------------------------------------------------------------
> mmednick's Profile:
> http://www.excelforum.com/member.php...o&userid=29404
> View this thread: http://www.excelforum.com/showthread...hreadid=571883
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks