ASAP Utilities, description of our Excel tools

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

Range » 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 » Range » Sort values inside each cell in selection...

« Return to the list of “Range” tools.

« Previous
Sort the data in random order

Next »
Flip selected cells

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: