ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Text » 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 line break (Alt+Enter)

Or enter your own separator
You can sort either ascending (A-Z) or descending (Z-A)

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

Screenshots

Starting this utility

In the Excel menu choose: ASAP Utilities » Text » Sort values inside each cell in selection...

« Return to the list of “Text” tools.

« Previous
Reverse text in selected cells

Next »
Change formulas to their calculated values

Excel 2010 with ASAP Utilities in the menu

Download ASAP Utilities

Additional keywords for this tool:
sort or reverse word order in a cell that is separated by a space, comma, or other delimiter.

Follow ASAP Utilities on Facebook

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: