ASAP Utilities released its new version (4.8.0) today!

Facebook

We're proud to officially announce the new version of ASAP Utilities! New exiting tools have been added and several improvements have been made. Do you often work with Excel's Filters or AutoFilters? Do you need to export your worksheets as separate workbooks? Did you ever wanted to change your conditional formatting to static formatting (like […]

How to: Save several worksheets together in a single new workbook

Select the sheets and right-click on one of them

In addition to my post for yesterday that demonstrated how to save worksheets as separate workbooks, this article will show how how to save several worksheets together in a single new workbook. To save several sheets from your workbook together in a new file, you can do the following in Excel: First select the sheets […]

How to: Select a number of worksheets and export each as a single workbook

Save worksheets as separate workbooks

I just received the following question from Azad from Australia: Hi, Is it possible to select a number of worksheets and export as a single workbook? As you probably already know, Excel itself doesn't have a option for this. It can be a time consuming job to save each worksheet as a separate workbook. Fortunately […]

PC Welt Germany: Useful extensions for Microsoft Excel

We're proud to mention that the free ASAP Utilities Home&Student edition was featured in the January 2011 edition of the German PC Welt in an article about apps (addins) for Microsoft Office. English Translation: "Useful extensions for Microsoft Excel....ASAP Utilities is a collection of Excel macros with several hundred commands for formatting worksheets and highlight […]

PC Magazine Netherlands: Ultimate free extra for Microsoft Excel

Cover PC Magzine 150

We're proud to mention that the free ASAP Utilities Home&Student edition is featured in the October 2011 edition of the Dutch PC Magazine in an article about apps (addins) for Microsoft Office. English Translation: "Firefox and Crome are well known for it, but Microsoft Office can also be improved with the use of extensions or […]

How do I remove all text before/after a specific character?

Example remove before a certain character

Quite frequently people ask us how to remove all content before or after a certain character. This is easy to do this with Excel's built-in Find and Replace. In this article I'll show you how. Hi! Does your software have a functionality to remove all content BEFORE a symbol in a column? For example: This: […]