logo ASAP Utilities

“Smart tools that speed up your workflow in Excel!”

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.

Reviews from users

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,500 organizations in more than 140 countries.

New version: September 20, 2006

Date: September 20, 2006

A new version of ASAP Utilities is just released. You can download 4.0.4, September 20, 2006.

Major reason for this release are a few bugfixes.

Thank you all for the feedback on version 4.0.3 and the preview version of 4.0.4!


Improved utilities

  • Delete leading and trailing spaces
    Cells with (array)formulas and errors will be skipped.
  • Delete leading, trailing and excessive spaces
    Cells with (array)formulas and errors will be skipped.
  • Numbers » Spell numbers or amounts (EN, DE, NL)...
    Your last used settings will be remembered.
    If you use rupees (Rs, IRs or NRs) the currency will be listed at the front.
    This will also affect the worksheet function =ASAPSpellNumber()
    For example:
    =asapspellnumber(2450.25,"EN","TRUE","Rs","Rs",,"Paisa","Paisa Only")
    would produce
    "Two Thousand Four Hundred Fifty Rs and Twenty Five Paisa"
    but wil now produce:
    "Rs Two Thousand Four Hundred Fifty and Twenty Five Paisa"
  • General
    I have changed the hotkey (accelerator) for the ASAP Utilities in the menu.
    By default this is the letter A (so you can access the ASAP Utilities menu with Alt+A.) However in some countries this conflicts with other menu items (such as &Ansicht as German for Menu). Therefore, in the following countries the hotkey is the letter S:
    . Germany (new)
    . The Netherlands
    . Sweden
    . Spain
    . Brazil
    . Portugal
  • Fill » Insert before / after
    Your last used settings will be remembered.

Bug fixes

  • Text » delete leading / ending characters
    In version 4.0.3 I excluded numbers from being altered by this version.
    That has now been undone, making this utility work on numeric data too.
    I thought excluding numbers was a better approach but apparently a lot of people use this utility to edit numbers too.
  • Import » Merge files...
    Produced an error if you had previously used the utility on files in a folder and this folder was no longer available. This is now fixed
  • Fill » Insert before / after...
    When you apply this utility to numbers ASAP Utililities will no longer convert these numbers to "textnumbers" by adding an apostrophe in front. The insert before/after on formulas has been improved too so that your formulas will stay formulas. You can now for example change a formula from =12*B4 to =12*B4+SUM(A1:A10)
  • Export » HTML Export...
    In april 2006 I've changed the NOBR setting in the HTML output from <NOBR>in each cell to a stylesheet setting for each row: style="white-space : nowrap;".
    However I found out this doesn't work as good as the old-school <NOBR>tag so I reversed this change and added the <NOBR>tag again.


Thank you all for the feedback!



« back


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


Empowering Excel Users Worldwide for 25 Years