Tip of the Day | Thursday November 20th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Sort Values Inside Each Cell...

This tool sorts the values within each selected cell, based on your chosen separator.

You can sort:

Alphabetically (A-Z)

Reverse alphabetically (Z-A)

Or reverse the current order

Supported separators:

Space

Comma

Comma + space

Semicolon

Line break (Alt+Enter)

Or a custom character of your choice

Examples:

"Orange, Apple, Banana" → "Apple, Banana, Orange" (A-Z)

"Q1;Q3;Q2" → "Q3;Q2;Q1" (Z-A)

"Red Blue Green" → "Green Blue Red" (reverse order)

Sorting values inside a single cell helps:

Clean up unordered lists (tags, categories, names, etc.)

Standardize data for duplicate checking or comparison

Prepare cells for lookups or matching

Improve readability in exports or forms

Create consistent input formats (e.g., skills, allergens, roles)

You can also use this in a temporary helper column to make it easier to find duplicates when the same values are listed in a different order.
Example: "Excel, PowerPoint" and "PowerPoint, Excel" are both sorted as "Excel, PowerPoint", so they can be matched more easily.

Screenshots

Starting this tool

Click ASAP Utilities › Text › 26. Sort Values Inside Each Cell...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

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

Yesterday's Tip

Tomorrow's Tip

Download

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

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.