ASAP Utilities for Excel

The "automated" tools within the add-in, are exactly what I want and need to use most. This allows me to work most effectively. How often are you working on source data file (exported from another system), although your data only extends 1-2K rows, the "range" within the sheet is far beyond 100K rows. Reset Excel's last cell to the rescue! That one has been moved to #1 on my ASAP favorites, along with deleting leading and trailing spaces.

This software provides several key functions to make items like sorting or manipulating Excel entries easier.

Easy to use. Offers a free trial version that may last 90 days. Innumerable types of macros that will make your life a whole lot easier. You can create shortcuts to your favorite utilities.

You can download and install this product in 2 minutes, then you will use it every day. I know formulas to do things like concatenate and If..then but it is easier just to click a menu option and have it done for me. I love reset last cell. I love remove first X characters - this doesn't change the cell formatting even if the first character is a minus sign, remove after X characters, convert unrecognized text to numbers, remove carriage returns, change the sign on numbers, change formulas to their calculated values, advanced sorting, transpose columns in multiples - as you can see I use many, many features and there are a lot. Most of the plain features offer several ways you can enhance them to do multiple steps at once. I also love the "start last tool again" feature.

I'm using this application for nearly 4 years, I use it everyday. It is a very helpful tool when comes to the excel. It is a lifeline for those who work on the excel everyday. You can import files and combine files without any Hussle. You remove diacritic and unwanted symbols, invisible spaces, and line breaks in a single shot. Joining data from rows and columns, inserting rows and columns are very easy and helpful.