Tip: Quickly remove spaces from the beginning and end of your data

Delete leading and trailing spaces

Save 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. "Easily trim all leading and trailing spaces" Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or trailing spaces can ...

Tip: Easily COUNT or SUM cells based on their Color

COUNT or SUM cells with a certain color

Save 5 minutes a day by using ASAP Utilities to quickly count or sum cells based on their background color. "Did you ever have to SUM by Color or Count by cell Color?" I have a column that needs summed, but only the cells that are green... Working with cell colors can help to make your Excel workbook ...

Tip: Quickly round the numbers in selected cells

Wrap formula around via the -Insert before and or after each cell in your selection- tool

Save 5 minutes a day by having ASAP Utilities quickly round the numbers for you. "Easily apply rounding to all numbers in your selection" It is a common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with this approach is that it can display totals that don't appear ...

Tip: Quickly reset the last cell and minimize the used range

Quickly reset the last cell on your sheet and minimize the used range

Save 5 minutes a day by using ASAP Utilities to quickly reset the used range on your worksheet. "Easily reset the last cell on your sheet" Have you ever been frustrated when Excel acts as if the active area of your worksheet is significantly larger than the actual area where you have data? Sometimes the last cell of ...

New ASAP Utilities 5.1 just released!

because-it-makes-YOU-rock-in-Excel-new-version51-150px

The new and improved version of ASAP Utilities has just been released! Based on the feedback we received, we've added many improvements to make your work in Excel easier, faster and more fun. Newsletter, see what's new http://www.asap-utilities.com/newsletter-2014-01.php Download the new version 5.1 You can download this new version from: http://www.asap-utilities.com/download.php If you have a license then you can download this new ...

Latest pre-release new version 5.1 now available

Latest pre-release new version 5.1 now available

We're happy to announce that the latest pre-release of the new version 5.1 of ASAP Utilities is now available. Many improvements have been made. If you use Excel 2013 or 2010 you will also see speed improvements when editing data formatted as Tables. We tested this pre-release thoroughly and have now made it available to you to help ...

Tip: Auto numbering on steroids

Quick numbering on filtered data too

Save 5 minutes a day by using ASAP Utilities to quickly insert a series of values into your cells. "Easily insert a series of values" Sometimes you need a bit more flexibility than Excel offers with its built-in Fill tool. For example to restart the count when a certain value is reached, add a pre-fix or suffix, auto ...

Tip: Easy ways to combine the contents of multiple cells

Merge column data (join cells)

Save 5 minutes a day by using ASAP Utilities to quickly combine the contents of multiple cells into once cell. "Is there a quick way to merge the contents of multiple cells?" We were recently asked: "Does ASAP have a quick alternative for merging the contents of many cells into a single one? Using ampersands or Excel's ...

Tip: Quickly fix the trailing minus sign for negative numbers

Fix trailing minus sign for negative numbers

Save 5 minutes a day by using ASAP Utilities to quickly fix numbers with a trailing minus sign. "How can I flip the minus sign and make it a real negative number?" We were recently asked: "I have downloaded a report that shows negative numbers as follows: 123.25- How can I make the negative symbol appear on the left?" Just ...

Tip: Easily keep only the filtered results

Keep only filtered results / remove all hidden rows and/or columns

Save 5 minutes a day by using ASAP Utilities to quickly remove all hidden rows and/or columns. "How can I quickly remove all hidden rows?" We were recently asked: "Does ASAP have a feature to convert filtered results 'in place' to convert a spreadsheet into just the filtered results? I know I can do it manually by ...