Bjorn's Super-SORT

Super-SORT allows you to sort cells in new ways: - By last word, e.g. by last name - By Nth word, e.g. by middle name - By length of text - By word count Now you don't have to extract data from one column to another just to do a simple sort. The add-on remembers the sorted ranges so you can resort all ranges with a simple click of a button. Free 7 day trial, then requires subscription.

Google Workspace Marketplace link