I was wondering if there were a formula I could use to sort column A (which has many names listed like "John Smith" (first and last name only) into column B in alphabetical order by last name? I have found a couple using SORT, INDEX, SPLIT...but they don't work. Thanks for any help.
Bookmarks