P p.conors Nov 6, 2003 #1 want to put a guest list in alphabetical order by last name in column A. i.e. Mrs. John Doe..
J Jason Morin Nov 6, 2003 #2 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
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
