You could extract the first letter of the last word with:

=MID(A1,MAX(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))), 1)="
",ROW(INDIRECT("1:"&LEN(A1)))))+1,1)

and then sort based on that. The formula above is an array formula, so be
sure to press <ctrl<shift<enter after inserting the formula. Then fill
down.

HTH
Jason
Atlanta, GA



"excelnewbie" wrote:

I am extracting one single column from word where the person's name is
written "Mr. John Smith." Is there any way in excel to have it appear as
"Smith, Mr. John" It can be in the same column but I need to be able to sort
by the last name - not the title!