Translation - Μετάφραση

Resources, Technical Assistance and Technology News => Translator resources => Tips on Using Computers => Topic started by: spiros on 12 Oct, 2022, 16:31:25

Title: Excel: Sort a list of values within a cell with any delimiter (comma, space, pipe, semicolon, etc)
Post by: spiros on 12 Oct, 2022, 16:31:25
Download the free Save time in Excel with ASAP Utilities. Easy, fast and reliable Excel tools. (https://www.asap-utilities.com)

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 (https://www.asap-utilities.com/faq-questions-answers-detail.php?m=347) 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) (https://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=278&utilities=42&lang=en_us)