ASAP Utilities Review 2026: Features, Pros, and Best Use Cases

10 Time-Saving ASAP Utilities Tricks Every Excel User Should Know

1. Delete leading, trailing, and excessive spaces — Remove extra spaces from selected cells in one step to fix messy imports.
2. Convert unrecognized numbers (text?) to numbers — Turn numbers stored as text into true numeric values so formulas and charts work correctly.
3. Delete all empty rows — Remove blank rows across a selection or entire sheet quickly without manual filtering.
4. Insert before and/or after each cell in your selection — Add prefixes/suffixes (e.g., units, quotes, separators) to many cells at once.
5. Change text case — Convert selections to UPPERCASE, lowercase, Title Case, or other casing options instantly.
6. Count and/or color duplicates in selection — Highlight or count duplicates to clean data and spot errors fast.
7. Merge column data (join cells) — Combine multiple columns into one with a custom separator, preserving order and values.
8. Fill blank cells with value above — Propagate the previous value down through blanks (useful for pivot-ready datasets).
9. Split selection into multiple worksheets / Export worksheets as separate files — Break large datasets into smaller sheets or save each sheet as its own file automatically.
10. Advanced character remove or replace — Remove or replace many different characters at once (e.g., non-printable chars, currency symbols, specific substrings).

Quick tip: add frequently used tools to your ASAP Utilities Favorites and assign shortcut keys to save even more time.