logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Sort values inside each cell in selection...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Range  ›  4. Sort values inside each cell in selection...

This tool sorts the contents of each cell in your selection.
You can choose if the cell contents are:
  • Separated by a space
  • Separated by a comma
  • Separated by a comma + space
  • Separated by a semicolon
  • Separated by a line break (Alt+Enter)
  • Or enter your own separator
    You can sort either ascending (A-Z), descending (Z-A) or in reverse order.

    Tip: You can also use this on a (temporary) extra column in preparation to identify duplicate cell values.

    Screenshots

    Range  ›  4 Sort values inside each cell in selection...

    Starting this tool


    Range  ›  4 Sort values inside each cell in selection...
    Additional keywords for this tool:
    sort or reverse word order in a cell that is separated by a space, comma, or other delimiter. sort inside cells


  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    Empowering Excel Users Worldwide for 25 Years