sort names by last name

[dshafique]

Hi guys, i have a set of data where the whole name is one cell, including the middle name. I want a formula which will organize it by last name, first name middle name. I have one formula which does something similar, but it gives me an error for cells that contain one word, like vacant, or something/guest

here's the formula i have

=MID(A2&", "&A2,FIND(" ",A2,FIND(" ",A2)+COUNTIF(A2,"* * *"))+1,LEN(A2)+1)

 

[drgerry]

Sorry . . . .
Most Last names are singular, occasionally we the the hyphenated name but the formula seems to work on those as well.
I will try your formula. I think that is going to be the best one.
Our PDF form sends a blank space when there is not a MI in the field . . . I could probably fix that in the form, but don't know how.

Thank you so much for helping, I do appreciate you.

 

[Peter_SSs]

.. occasionally we the the hyphenated name but the formula seems to work on those as well.

Yes, hyphenated names will be fine. It is only if there are spaces in the last name like the examples I gave there will be a problem. Let's hope you don't have any of those.