I don't think that there is a direct way of doing what you want if both first and last names are in the same cell where the first name comes before the last name and you want to sort by last name. You would have to insert a blank column and place just the last name in that column and then use that column to sort. Once the sorting is done, that new column can be deleted. Another complication is if there are middle names or initials.