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

[spiros]

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)