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 ...

Tip: Quickly select or filter by strikethrough formatted text

Sort by strikethrough formatting

Save 5 minutes a day by using ASAP Utilities to quickly select or filter by strikethrough formatted cells. "How can I filter for items that have a 'Strikethrough'?" Strikethrough formatting (my struck through text) is often used to mark tasks as being completed or items to be ready for removal. The quickest way to apply this type ...

Tip: Easily transpose 1 column into multiple rows, creating a table

Transposes data from one column into a table

Save 5 minutes a day by using ASAP Utilities to quickly transpose your single column into a table. "How to quickly change a long list to a table?" Have you ever had data in a single column that you manually needed to "Copy > Paste Special > Transpose" over and over again to get it into a ...

Tip: Easily insert an English formula in your non-English Excel version

Easily paste English formulas into your local Excel version, such as for example a Dutch Excel version

Save 5 minutes a day by using ASAP Utilities to insert English formulas you found as examples. "How to use English formula examples in your local Excel version?" On the Internet you can find an enormous amount of useful formulas for Excel. Most of these examples use the "international" formula notation. They use English function names, a comma ...

Insert random dates and times in Excel

Example - Random dates and times

We just received the following question: "Would it be possible to add random date and times?" Yes, this can (already) be done with just Excel. We might add a tool for it in ASAP Utilities that will ask you for the input in the future, but it isn't hard to do yourself with the combination of a few ...

Tip: Easily change the text in selected cells to UPPERCASE

Easily make text uppercase

Save 5 minutes a day by using ASAP Utilities to quickly change your text to uppercase. "How to quickly capitalize all text" Have you ever had data in a worksheet where all the text was all lowercase? Then you had to retype it all to get it into uppercase? No more! Just select the cells and then start: ASAP ...