If you’re using Microsoft Word and you need to put a list in alphabetical order based on the second word in each list entry, e.g. by surname in a list of names, here’s how:

  • Highlight the text list.
  • Click on the A-Z button in the top menu (Home > Sort), and ‘Options’ (bottom left list).
  • Select ‘Other,’ delete and any characters in there, press the spacebar (moving the cursor one space to the right), and click on ‘OK.’
  • In the dropdown ‘Sort by’ menu, select ‘Word2’, and click on ‘OK’.
  • The list will now be re-arranged into alphabetical order for the second word / surname.

Email: hello@gmal.co.uk

Visit our contact us page

Or call 020 8778 7759

Back to Tech News