Do you ever wonder which tools other users rely on the most in ASAP Utilities?As we begin 2025, let's take a moment to reflect on the 25 tools that were used most frequently by our community last year. These tools saved time, simplified tasks, and made working in Excel faster and easier for nearly a million users worldwide.
Each tool in this list demonstrates the versatility and power of ASAP Utilities, whether by combining several steps into one for greater efficiency or enabling tasks that are not, or not easily, possible in Excel alone. They reflect the tasks our users rely on most frequently to simplify their work.
The 25 Most-Used Tools of 2024
(Listed with the most-used tools at the top)
- Delete leading, trailing, and excessive spaces
- Delete leading and trailing spaces
- Change to UPPERcase
- Convert unrecognized numbers (text?) to numbers
- Delete all empty rows
- Insert before and/or after each cell in your selection...
- Start Each Word With Uppercase
- Change to lowercase
- Clean data and formatting...
- Start first word with Uppercase
- Make first character Uppercase, the rest lowercase
- Advanced character remove or replace...
- Convert/recognize dates...
- Change formulas to their calculated values
- Merge column data (join cells)...
- Delete number of leading characters...
- Find and run a utility...
- Copy values to empty cells below filled cells in selection
- Count and/or color duplicates in selection...
- Export worksheets as separate files...
- Change negative numbers to positive and vice versa...
- Count duplicates and give each set of duplicates its own color
- Delete number of ending characters...
- Merge and/or import multiple files...
- Start the last used utility again...
Want to know which tools you use the most and how much time you've saved?
Find out for yourself:
Go to ASAP Utilities › ASAP Utilities Options › 16. Show me the time that I saved by using ASAP Utilities.
These tools highlight how ASAP Utilities continues to simplify Excel for professionals worldwide while unlocking possibilities that go beyond Excel’s standard features.
Which tool did you use the most? Let us know in the comments on Facebook or LinkedIn!
We look forward to helping you save even more time in 2025.
Power to you!
The ASAP Utilities Team