excel list

[p.conors]

want to put a guest list in alphabetical order by last
name in column A. i.e. Mrs. John Doe..

 

[Jason Morin]

Try this formula in B1 and fill down. Then sort on column
B:

=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN
(SUBSTITUTE(A1," ",""))))+1,255)

HTH
Jason
Atlanta, GA