Sit down and relax while ASAP Utilities does the rest!

User Guide

The ASAP Utilities User Guide (PDF) is a practical manual that will show you how to get the best out of this excel add-in.
To receive the User Guide by mail, send an email to
userguide@asap-utilities.com and you will get an automated reply with the file (8.7 MB) attached.

Not able to download?

We can send you the new version by email. The file is 2.3 MB
Send your request to:
download@asap-utilities.com
This setup does not include the User Guide.

Installation

It is not necessary to uninstall the previous version before installing the new one. Make sure Excel is closed and then run the setup.

Uninstall

If you want to uninstall ASAP Utilities, use the option "remove ASAP Utilities from your computer" in your ASAP Utilities start menu. Detailed information is also available on our website and in the User Guide.

Upgrade twice a year

Since 2001 it's our policy to force an upgrade (free) every half year to make sure you are always using the best and most complete version.

Purchase ASAP Utilities

Read the benefits and buy a license online.
Safe secure and fast

New ASAP Utilities version 4.2.6 released!

In this newsletter

• Upgrade to the new version
• What's new
• Bugs fixed in version 4.2.6
• When to buy a license

“We make you the company's Excel guru!”

Upgrade to the new version

New and improved utilities

• Text » Replace accented characters (á, ë, ñ etc.)...
  The character ő has been added to be replaced with a normal o.
• Export » Copy sum of selection to clipboard
  Changed so that it only calculates the sum of the visible cells in case of a filtered list or hidden cells. Although the sum that Excel displays in the statusbar only skips hidden rows, ASAP Utilities will also skip hidden columns in your selection.
• Export » Copy average of selection to clipboard
  Changed so that it only calculates the average of the visible cells in case of a filtered list or hidden cells. Although the sum that Excel displays in the statusbar only skips hidden rows, ASAP Utilities will also skip hidden columns in your selection.

Bug fixes

• Fill » Random numbering of cells (without duplicates)
  Returned an error if only one cell was selected. This is now fixed.
• Columns & Rows » Merge row data (join cells)...
  Didn't work when you entered only one or more spaces and trailing spaces were cut off. This is now fixed.
  Furthermore you can no use the utility to have the data merged without a separator at all.
• Columns & Rows » Merge column data (join cells)...
  Fixed the bug where empty cells in the first column in your selection were not ignored, despite the fact that you choose this option.
• Fill » Insert before current value...
  When you inserted a single quote (') in front of every cell, the quote wasn't visible. By default Excel uses the single quote to identify the value in the cell as text. 
  You can for example enter '3-4 in a cell and then Excel doesn't automatically change it to a date-value. ASAP Utilities will now automatically add double single quotes if you entered a singe one in the utility so that is will be visible. (This bug was introduced in version 4.2.5)
• Fill » Insert current time with seconds
  The default shortcut Control+Shift+T has been changed to Control+Alt+T.
  We weren't aware that the shortcut Control+Shift+T was used for the find function in the Italian version of Excel. In the Dutch and French version of Excel the shortcut for the find is the same as the international version, Control+F and most other languages use Control+B for the find dialog.
• Fill » List filenames in folder...
  The column 'Last Accessed' wasn't filled, now it is again.
• Columns & Rows » Advanced Transposer...
  The start-button now has the focus when the utility is started. The tab-order is now correct too.
• Fill » Copy values to empty cells below filled cells in selection
  'Text' numbers (numbers beginning with an apostrophe) were converted to regular numbers when copied down. This is now fixed.
• Numbers » Use a significant number of decimals...
  The utility was accidentally listed twice in the numbers-submenu.
• Select » Select adjacent cells below active cell with the same value
  The utility used to be based on the equal formula in adjacent cells, now it is based on the (calculated) value of adjacent cells.
• Select » Select adjacent cells in column with the same value
  The utility used to be based on the equal formula in adjacent cells, now it is based on the (calculated) value of adjacent cells.
• Range » Delete all range names in the entire workbook
  Fixed a bug where in some case difficult/corrupt names were not removed.
• Information » Count unique values in selection
  Fixed a bug when in certain situations a number too small was reported. Furthermore the utility can now also handle a larger selection and longer cell values.
• Sheets » Freeze panes on multiple sheets at once
  Fixed a bug when in certain situations the visible region wasn't set properly.
• Columns & Rows » Insert in-between empty rows or columns...
  Fixed a small bug and improved speed.
• Numbers » Convert "textnumbers" to numbers
  Fixed the bug where dates written long, such as 7/16/2008 10:09:00 AM could be converted to 'text' numbers.
• Web » Clean Web Imported data...
  Fixed the bug where dates written long, such as '2-3-2008  13:39:00' could be converted on systems with non US date settings from March 2nd to February 3rd. This error occurred if you had the 'trim spaces' option checked.
• Text » Delete leading and trailing spaces
  Fixed the bug where dates written long, such as '2-3-2008  13:39:00' could be converted on systems with non US date settings from March 2nd to February 3rd.
• Text » Delete leading, trailing and excessive spaces
  Fixed the bug where dates written long, such as '2-3-2008  13:39:00' could be converted on systems with non US date settings from March 2nd to February 3rd.
• Range » Find / Replace in all sheets...
  Improved so that it ignores other applications/add-ins during the process.
  This solves a problem the add-in XLplus could cause when also installed.
  Fixed a few bugs that could occur when the 'Range' option was selected. One if this was the 'Replace all' in the selected range performed the action on the entire sheet instead of the selected range. Furthermore, if the 'replace with' values contained the 'Find what' value, the replace action was duplicated multiple times.
• Columns & Rows » View and manage hidden rows and columns...
  Produced an error when the first cell in a hidden row or column contained an error. This is now fixed.
• Setup
  On a few computers during the setup there was an error:
  Runtime Error (at 1:145): RegSvr32 failed with exit code 0x5
  This fixed in this version.

When to buy a license?

• if you use it for commercial purposes (Feel free to try it for 90 days. If you like it, simply purchase a registration key online via our e-commerce partner RegNow)
• or if you don't want to be forced to update to the new version twice a year
• or if you like this program and think it is worth the money

Key benefits of registration

• use it in a commercial organization
• no forced updates twice a year
• priority support via email
• free upgrade to all 4.x versions

Online ordering, safe secure and fast

• Single user license: US $49.00
• The price is a one time fee, not a yearly subscription.
• We offer generous volume discounts (save 20% to 86%)
• You can pay in the following currencies: US Dollar (USD), Euro (EUR), Pound Sterling (GBP), Australian Dollar (AUD), Canadian dollar (CDN), Swedish Krona (SEK), New Zealand Dollar (NZD), Norwegian Krone (NOK), Yen (JPY), Hong Kong Dollar (HKD), Danish Krone (DKK), Swiss Franc (CHF), Rand (ZAR), Singapore Dollar (SGD) and Yuan Renminbi (CNY)
• There is no shipping or handling fee
• You can also get ASAP Utilities on a cd-rom by postal mail for an additional USD 12.50
• After the order is completed you get your registration code within a few minutes.

Instant delivery

More information and demonstration