¿Habla usted español? – Pre-release version 4.5.5

bordersign-spain.jpg

¿Habla usted español? (Do you speak Spanish?) Then I have good news for you: ASAP Utilities is now also available in the Spanish language. If you have the Spanish language version of Excel then ASAP Utilities will start the first time automatically in Spanish (Español). You can change the language in the options dialogue: ASAP Utilities » ASAP ...

New ASAP Utilities version available: 4.5.4

Home grown strawberry

ASAP Utilities version 4.5.4 (September 1, 2009) has just been released! We're proud to announce that the new version of ASAP Utilities is available in the German language too. We have also added two new tools and made several improvements. More information is in the newsletter.

New tool: How much time (and money) does ASAP Utilities save you?

Show the time that ASAP Utilities has saved you

These days, with all the economical issues, it is more then ever important to see where you can save money. You have probably already heard from others or experienced yourself that ASAP Utilities can save you a lot of time with your work in Excel. But how much time (and money) does it actually save ...

Macro: Keep only ASCII characters 32-127

Last week I received the following question: I get sent Excel files from various vendors. I have to convert these to SAS datasets that get moved to a UNIX system. The SAS datasets can only contain ASCII 32-127. So I need to remove these from the Excel file. You can use the "Text » Advanced character remove ...

How to: Remove all negative numbers

Select the negative numbers

Last week I received the following question: Is there an ASAP Utilities function that can remove all negative numbers from a spreadsheet? I haven't found it yet. Yes there is. You can use ASAP Utilities to help you to quickly delete negative numbers. You can use the following tool to select all cells with negative numbers (values ...

How to combine numerous sheets into a single sheet

I recently receive the following question: Is there a way to combine numerous Sheets into a single Sheet? I have an Excel document with 72 sheets, that I would like to be 1 continuous sheet. Thanks again for your help. You can use the following tool to put together the rows or columns from multiple ...

Identify duplicates

I just received the following question: I will like to know how I can see the duplicates in a selection data? I'm aware I can delete duplicates, however I will like to know how to identify them first before deleted. Here's how to do this: You can use the following tool to select the cells with duplicated values: ...

Download pre-release version 4.5.4: German edition

bordersign-bundesrepublik-deutschland

ASAP Utilities is now also available in the German language. If you have the German language version of Excel, ASAP Utilities will now start in German (Deutsch). You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings... In ASAP Utilities you can now choose between the ...

Video: How to move or resize the selected range in Excel with ASAP Utilities

0003-1-move-or-resize-selected-range

The following video will show you how to how to move or resize the selected range in Excel by using ASAP Utilities. With this utility you can easily move or resize your selected range of cells. This utility will only change you selected range of cells only, not the data underneath it. By default you can start this ...

Just released: ASAP Utilities 4.5.2!

Notes

The new version of ASAP Utilities, 4.5.2 May 1th 2009, has just been released. Download ASAP Utilities, 4.5.2 May 1th 2009 Most of the updates in this new version are bug-related. The bugs that were reported after the recent release of version 4.5.0 and 4.5.1. have been fixed in this new version. Furthermore a few (minor) improvements ...