Excel: Sort a list of values within a cell with any delimiter (comma, space, pipe, semicolon, etc)

spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 851007
    • Gender:Male
  • point d’amour
Download the free Save time in Excel with ASAP Utilities. Easy, fast and reliable Excel tools.

1. Select the cells
2. Go to ASAP Utilities > Range > Sort values inside each cell in selection
3. Select a predefined delimiter or add yours

Up until recently this did not work with Unicode characters (i.e. Greek polytonic). From version 8-0-2_RC1 onwards, it does, if you have Excel 2021 or Excel 365 as it uses Excel's new built-in SORT worksheet function to do the sorting.

Text  ›  26 Sort values inside each cell in selection... (English)
« Last Edit: 13 Oct, 2022, 13:30:06 by spiros »


 

Search Tools