logo ASAP Utilities

“The right tools increase efficiency!”

Excel with ASAP Utilities in it's menu

Version history

A history of the various updates and improvements throughout the years

Awards & Reviews

Read the awards & reviews from magazines, newsletters and radio shows.

Testimonials

See what our users are saying about ASAP Utilities

Receive our newsletter

Receive an email as soon as a new version of ASAP Utilities is released

Trusted daily by over 26,000 organizations

Our list of clients exceeds 26,000 organizations in more than 140 countries.

What's new on ASAP Utilities

We'll keep you updated about new releases of ASAP Utilities. If you want to receive an email as soon as a new version is released, then subscribe to our newsletter. The news is also available as an rss-feed

ASAP Utilities 3.03 is now available for download.

New features:
Text - Date Converter This will convert a text-string-date to another formatted date. I.e. 010101 becomes 1 january 2001, or 2001-12-02 becomes 12 feb 2001.
When it comes to importing data from i.e. financial systems, this feature is extremely usefull. Whether the original date is like "mmddyy" or "ddmmyy" this utility will recognize and convert it!
The conversion is very flexible.
Undo I've built an undo option in a few functions. In time most functions will get an undo.
Select Conditional select, added options to select cells that are NOT bold, underlined or italic.
Range Randomize list, by row. Easily randomize the order your list is shown.
Sheets Add sheet (inputbox will appear for the name) If you enter a name that exceeds 31 characters ASAP will automaticly reduce it to 31 characters.
Custom formulas ASAPCountShades() ? Counts the number of cells that are colored within the given range.
ASAPSumByFontColor ? Sums the cells with a given color in a given range. The color is Excels colorindex (1-56).
ASAPFontColorIndex ? Returns the fonts colorindex number (1-56).


ASAPFullFilename() ? Returns the full path and filename of the active workbook
ASAPFileName() ? Returns the filename of the active workbook
ASAPFilePath() ? Returns the path of the active workbook
   
Bug fixes:
Import Merge files together in a new file. The ability to import each file on a new sheet is now available.
HTML export removed double ">>" when exporting without a font attribute.
Select Conditional select. Fixed the bug when trying to select text that was "not like"
Range Custom formula error message (hide errors) updated, will now work with in all languages.
Text Make last character super- or subscript will no longer give you an error message if there is a numeric cell in the target selection.
Quicknumber Fixed the error when the leading zero's was less then the number-length. (i.e. 2 leading zero's on 100).
Update info Fixed the "error 13" on Excel 97 machines, when the update information appears.
I've also added an option not to hide the update-reminder for a period of 10 days.

News on ASAP Utilities 3.03

New features:
Text - Date Converter This will convert a text-string-date to another formatted date. I.e. 010101 becomes 1 january 2001, or 2001-12-02 becomes 12 feb 2001.
When it comes to importing data from i.e. financial systems, this feature is extremely usefull. Whether the original date is like "mmddyy" or "ddmmyy" this utility will recognize and convert it!
The conversion is very flexible.
Undo We've built an undo option in a few functions. In time more most function will get an undo.
Sheets Add sheet (inputbox will appear for the name) If you enter a name that exceeds 31 characters ASAP will automaticly reduce it to 31 characters.
   
Bug fixes:
Import Merge files together in a new file. The ability to import each file on a new sheet is now available.
HTML export removed double ">>" when exporting without a font attribute.
Range Hide errors updated, will now work with in all languages.
Text Make last character super- or subscript will no longer give you an error message if there is a numeric cell in the target selection.
Quicknumber Fixed the error when the leading zero's was less then the number-length. (i.e. 2 leading zero's on 100).

ASAP Utilities 3.02 is released!

I would like to thank all the people that have been sending me their comments and suggestions. Unfortunately due to the large amount of email I'm no longer capable of answering everybody. However we collect all your suggestions and implement most of them in (future versions of) ASAP Utilities.
Thank you all for the great ideas (and patience too) !

New or improved functions:
Read the rest of this story »

Lockergnone: 'You'll wonder how you lived in Excel without it, I swear!'

Click to visit Lockergnome.comIn october 2001 Lockergnome, a big free technology e-mail newsletter, wrote a review about ASAP Utilities in their newsletter and on their website:

'Many of you liked the ASAP Utilities for Excel featured some time back in the Tech Specialist, so when the author mentioned his new version was available, I figured you'd want to know. The gaggle of tools included most definitely make Excel easier to use all the way around. It simplifies some rather complex tasks into short operations, saving you plenty of time better suited to hanging out eating bagels with your co-workers. You'll wonder how you lived in Excel without it, I swear!'

http://channels.lockergnome.com/it/backissues/20011001.phtml


PC Plus: "It's worth having these utilities even if you only use a few of them"

Users of Excel 97 and 2000 may like to download ASAP Utilities from www.asap-utilities.com. This free add-in gives you 200 extra tools for Excel, or 300 in the beta of the new version. It's worth having even if you only use a few of them.

« previous 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 next »



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us