I'm currently ordered to sort a list with ~250 entries alphabetically. Problem is: Not using the first word(s), or a specific column, but using the last term before the first comma:

[li]title surname1 name1, occupation, city[/li
][li]title surname2 name3, occupation, city[/li
][li]title surname3 name3, occupation, city[/li]

I'm currently trying to not do this manually. Any idea how to do this?

  • Did you ever work this out? You can answer your own question if so – MrLore Jul 3 '17 at 12:18

Save your data to a text file and open it in MS Excel or LibreOffice Calc (free) as "comma delimited", but in your case change the delimiter to space. You can then sort and filter on any column you want.

Excel Import Wizard looks like this: enter image description here

  • Nice idea, but many items have multiple titles, surnames or names, resulting in very different columns for the last names. – senthor May 4 '16 at 12:00
  • Sorry, I assumed the structure was consistent. You can import to Excel as comma delimited and then split the first column using an Excel function, then sort on the extracted "last name". – Atzmon May 4 '16 at 12:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.