Sort values inside each cell in selection...

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

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

Click ASAP Utilities › Range › 4. Sort values inside each cell in selection...
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

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

Sort the data in random order

Flip selected cells

Download

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years