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 (18.2 MB) attached.

Not able to download?

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

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. This does not apply to users with a license, they can choose their own time to upgrade to the new version.

Purchase ASAP Utilities

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

New ASAP Utilities version released!

In this newsletter

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

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

Upgrade to the new version

New and improved utilities

• All the tools are also available in the Dutch language (Nederlands) now.
  If you have the Dutch language of Excel, ASAP Utilities will now start in Dutch, otherwise it will start in English.
  
  In Excel 2007, English:
  
  In Excel 2007, Dutch/Nederlands:
  
  You can change the language used in menus and dialogs in the options dialogue:
  ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
  
  
  Note: Only ASAP Utilities itself is translated at this moment. The setup is still in English and so is our website.
  
• ASAP Utilities Options » Find your utility (search help)...
  The layout is improved and you can now quickly start the utility from the list of results, or click on the ?-button to view more details on the utility on our website:
  
  
  back to top
• Vision Control...
  The form has been redesigned to show better if the settings are for the worksheet, entire workbook, or the application:
  
  The option "Commandbars" has been renamed to "Toolbars". Disabling the toolbars now no longer disable the right-click toolbars. Furthermore you will be asked a question upfront which provides some useful information on what this option actually does:
  “Do you want to disable all the toolbars?
  This can be a useful alternative for Excel's "full screen" option. You free up up screen space and in contrary to the "full screen" option the formula- and statusbar are still being showed.
  You can later re-enable the toolbars by enabling this option in ASAP Utilities (this is important to remember).”
  back to top
• Select » Conditional select cells...
  has been renamed to:
  Select » Select cells based on content, formatting and more...
  
• Select » Conditional row and column select, hide or delete...
  The form has been redesigned to reflect the options better:
  
  
  back to top
• Columns & Rows » Put together rows or columns from several sheets...
  The form has been redesigned to reflect the options better:
  
  
• Range » Find / Replace in all sheets...
  The form has been redesigned to reflect the options better:
  
  
• Columns & Rows » Color each n'th row or column in selection...
  The form has been redesigned to reflect the options better:
  
  
  back to top
• Columns & Rows » Advanced Transposer...
  has been renamed to:
  Columns & Rows » Transpose column in multiple steps...
  
  
• Numbers » Convert "textnumbers" to numbers
  has been renamed to:
  Numbers » Change not recognized numbers (text?) to numbers
• Text » Convert dates...
  Has been redesigned, expanded and renamed to:
  Text » Convert/recognize dates...
  
  
  back to top
• Text » Advanced character removal/replace...
  The form has been slightly redesigned:
  
  
• Text » Replace accented characters (á, ë, ñ etc.)...
  The form has been slightly redesigned:
  
  
  back to top
• Fill » Quick numbering of cells...
  Has been redesigned and now also contains the option to restart the count after a certain number.
  The utility will now also count better when cells are merged (the merged area will now be counted as 1).
  
  
• Fill » List filenames in folder...
  Has been renamed to:
  Fill » Create a list of filenames and properties in a folder...
  back to top
• Format » Copy a sheet's page and print settings...
  The form has been slightly redesigned.
  Information is added that your printer-driver might affect the speed of the tool.
  
  
• Format » Insert workbook's path and name in header, footer or cell...
  The form has been redesigned. If you hover your mouse over one of the options you will see the value that will be inserted:
  
  
  
  back to top
• Format » Detect and visualize adjacent data/group changes
  The form has been redesigned:
  
  
• Format » Copy and apply cell's formatting settings...
  The form has been redesigned:
  
  
  back to top
• Objects & Comments » Comment tools...
  The form has been redesigned:
  
  
• Web » Export selection as HTML table to clipboard...
  The form has been redesigned:
  
  
  back to top
• Import » Merge files together in a new file...
  The form has been redesigned and has been renamed to:
  Import » Merge and/or import multiple files...
  
  
• Export » Export selection or active sheet as new file...
  The form has been redesigned:
  
  
  back to top
• Columns & Rows » Insert in-between empty rows or columns...
  The form has been redesigned and the utility has been renamed to:
  Columns & Rows » Insert between empty rows or columns...
  Furthermore you can now specify the amount of rows or columns to insert between:
  
• The "Launch" submenu has been renamed to "Start".
  We have done this because in Windows, "Start" is the name of the place where you start your programs too.
  
  
  back to top
• Information » List all range names
  If you have Excel 2007 this utility will now also report the name comments.
• Formula » Copy formulas without changing their cell references...
  Improved speed.
• Select » Conditional select cells...
  This utility was case sensitive, meaning that for example "Excel" and "EXCEL" were different values. You can now specify if you want the comparison when looking for duplicated values to be case sensitive or not. By default the utility is now no longer case sensitive.
  
  back to top
• Range » Empty duplicates in selection...
  This utility has been renamed to:
  Range » Clear duplicated values in selection (leave one original)
  When searching for duplicate or unique values, this utility was case sensitive, meaning that for example "Excel" and "EXCEL" were different values. You can now specify if you want the comparison when looking for duplicated values to be case sensitive or not. By default the utility is now no longer case sensitive.
  
• Columns & Rows » Conditional row and column select, hide or delete...
  When searching for duplicate or unique values, this utility was case sensitive, meaning that for example "Excel" and "EXCEL" were different values. By default the utility is now no longer case sensitive. When searching for text, you can now specify too if the comparison should be case sensitive.
  
  back to top
• Formula » Insert Function from the ASAP Utilities library...
  This utility has been added to help you insert a formula from the ASAP Utilities functions library.
  
• General
  In case of problems you can now activate the debug mode by creating an (empty) file in the ASAP Utilities program folder and name it 'debug.txt' (without the quotes). In your windows temp folder you will then see a file called 'asap-utilities-debug.txt' which contains information that might help us in solving certain issues. You can quickly open the temp folder in Windows explorer by choosing "Run" in the Windows Start menu and then entering '%TEMP%' (without the quotes).
• Columns & Rows » Conditional row and column select, hide or delete...
  Improved speed when hiding or removing the results.
  back to top
• ASAP Utilities Options » Find your utility (search help)...
  Has been renamed to "Find and run a utility..."
• Main menu: "User Guide (pdf)" has been replaced with "Find and run a utility..."
  The link to the manual is now located at:
  ASAP Utilities Options » Open the ASAP Utilities User Guide (English, PDF)...
  The "Find and run a tool..." is more powerful and therefore located in the main menu now. With this utility you can search for a tool, view the description and immediately press the "run" button.
  
• Range category
  The order in which the tools are displayed is changed so that the range sorting tools are showed together. Furthermore the "Count and/or color duplicates in selection..." utility from the "Information" submenu is now in the "Range" submenu too, right below the utility "Clear duplicated values in selection (leave one original)".
• Text » Convert to UPPERcase
  has been renamed to:
  Text » Change to UPPERcase
• Text » Convert to lowercase
  has been renamed to:
  Text » Change to lowercase
  back to top
• Formula » Convert formulas to their values
  has been renamed to:
  Formula » Change formulas to their calculated values
• Web » Convert hyperlinks to =HYPERLINK() formulas
  has been renamed to:
  Web » Change hyperlinks to =HYPERLINK() formulas
• Numbers » Convert negative numbers to positive and vice versa...
  has been renamed to:
  Numbers » Change negative numbers to positive and vice versa...
  back to top
• Range » Convert cells value to its formatted look
  Has been renamed to:
  Range » Fill cells with their formatted value
• Numbers » Convert numbers to text (adding ' in front)
  has been renamed to:
  Numbers » Change values to text values (adding ' in front)
• Information » Count unique values in selection
  has been renamed to:
  Information » Count the different unique values in selection
  You now have to option to only count the unique values within the visible cells in your selection. This can be useful for example if you are working with filtered lists.
  
  back to top
• Select » Expand selection to last used row
  Has been renamed to:
  Select » Extend selection to the last used row
• Select » Expand selection to last used column
  Has been renamed to:
  Select » Extend selection to the last used column
• Select » Select cell with smallest number
  has been renamed to:
  Select » Select cells with the smallest number
  Instead of only selecting the first found cell with the smallest number this tool will now select all cells with the minimum value within your range or on your worksheet.
• Select » Select cell with largest number
  has been renamed to:
  Select » Select cells with the largest number
  Instead of only selecting the first found cell with the largest number this tool will now select all cells with the maximum value within your range or on your worksheet.
  back to top
• Text » Replace accented characters (á, ë, ñ etc.)...
  The following characters have been added: ý, ů, ě, ā, ē, ī, ū, ę, ą, ÿ, and ű.
  If you have used this utility before you have to press the 'reset' button to have these new characters added.
• Web » Decode all URL-encoded data
  The utility has been renamed to:
  Decode all URL and HTML encoded text
  This utility will no also decode named html entities such as   €.
  Furthermore it will decode entities such as %c3%84 and %c3%a7 and it will decode unicode characters such as © and “.
• Export » Export selection as HTML table to clipboard...
  New option: Cell character encoding, Characters such as < > & and Unicode characters will be converted to their html entities so that they are properly displayed in a browser.
  The <nobr> option has been replaced by nowrap because <nobr> is not approved by the World Wide Web Consortium (W3C). Instead of encoding the cell's value with <nobr></nobr> the utility now adds 'style="white-space: nowrap"' within the <td> tag.
  back to top
• Columns & Rows » View and manage hidden rows and columns...
  The utility will now show between brackets the total amount of rows and columns that are hidden:
  
• Text » Delete all after n'th character...
  The utility has been renamed to:
  Delete all after a given amount of characters...
  back to top
• Sheets » Delete all pagebreaks in active sheet
  Has been renamed to:
  Sheets » Remove all page breaks on the selected worksheets
  Instead of working only on a single worksheet this utility now removes all manually set pages breaks from your selected worksheets.
  In Excel you can only remove all page breaks one sheet at a time by first selecting all cells and then choosing "Reset All Page Breaks" in the "Insert" menu. With this utility you can now easily remove the page breaks on multiple sheets at once and you don't need to select all cells upfront.
• Web » Extract hyperlinks...
  The utility now also extract the subaddresses in the link (the part after the #) and the utility also extracts the link from cells with the =HYPERLINK() function.
• ASAPGETHYPERLINK()
  This function now also extracts the link from cells with the =HYPERLINK() function.
  back to top
• Web » Clean information that is copied from websites...
  has been renamed to:
  Web » Clean information that is copied from websites...
• Export » Save selected range as bitmap-image on the clipboard (as on screen)
  has been renamed to:
  Export » Put selected range as bitmap-image on the clipboard (as on screen)
• Export » Save selected range as image on the clipboard (as on screen)
  has been renamed to:
  Export » Put selected range as image on the clipboard (as on screen) Export » Save selected range as image on the clipboard (as on printer)
  has been renamed to:
  Export » Put selected range as image on the clipboard (as on printer)
• Format » Copy and apply cell's formatting settings...
  has been renamed to:
  Format » Copy the formatting attributes of a cell...
• General
  Improved progress indicator and refreshing the screen when you switched to other applications during lengthy operations.
• Several minor improvements.

Bug fixes in version 4.5

• Import » Merge files together in a new file...
  When you import Excel files the column width is now preserved.
• Import » Merge files together in a new file...
  If you imported a file with the extension CSV, your custom settings were ignored, and the file was always split by your Windows list separator. This is now fixed.
• ASAP Utilities » Import » Insert Textfile (with options)...
  Fixed the error Method '~' of object '~' failed. This could happen if you started Excel and then immediately imported a file without any editing of the blank workbook Excel started with. Excel then just opened the file and closed the blank workbook which caused the error in ASAP Utilities.
• General, menu
  If the Excel menu bar was protected (a very rare situation) you could get an error stating that the ASAP Utilities menu could not be created: "Sorry, I can't create the menu due to an error... Method '~' of object '~' failed."
  This is now fixed. We have created a workaround for this by temporarily removing the protection, creating the menu and then applying the original protection settings again.
  
  An example of a setting that can be used to protect the menu and resulted in the error in ASAP Utilities: Application.CommandBars(1).Protection = msoBarNoCustomize
• Columns & Rows » View and manage hidden rows and columns...
  Fixed the error when you used the utility in Excel 2007 on a workbook that was opened in compatibility mode and it had only 255 columns instead of 16384.
• Text » Delete number of leading characters...
  If you used the utility on a range that contained a cell with a date you got an error. This is now fixed by skipping all cells with a date.
• Text » Delete number of ending characters...
  If you used the utility on a range that contained a cell with a date you got an error. This is now fixed by skipping all cells with a date.
• Text » Delete all after n'th character...
  If you used the utility on a range that contained a cell with a date you got an error. This is now fixed by skipping all cells with a date.
• Sheets » Sort all sheets...
  The utility produced an error if you workbook contained a hidden sheet that had the visible property set to xlVeryHidden: "Move method of Worksheet class failed". This is because a xlVeryHidden sheet can not be moved. Therefore this utility now skips the sheets that are hidden like that.
• Select » Select all sheets
  Didn't work and gave an error when one or more sheets in your workbook were hidden. This is now fixed.
• Text » Make first character Uppercase, the rest lowercase
  Gave an error if the formatting of the cells was protected. This is now fixed.
  The utility also gave an error on cells with very long text, this is fixed too.
• Text » Convert to UPPERcase
  The utility didn't work and gave an error on cells with very long text values. This is now fixed.
• Text » Convert to lowercase
  The utility didn't work and gave an error on cells with very long text values. This is now fixed.
• Text » Start first word with Uppercase
  The utility didn't work and gave an error on cells with very long text values. This is now fixed.
• Text » Start Each Word With Uppercase
  The utility didn't work and gave an error on cells with very long text values. This is now fixed.
• Web » Activate hyperlinks (create from cell values)
  The =HYPERLINK() option does not work if the length of the address exceeds 255 characters. This would result in an error. ASAP Utilities will now warn you upfront if any of the cells is too long to use the formula option.
• Web » Convert hyperlinks to =HYPERLINK() formulas
  The =HYPERLINK() option does not work if the length of the address exceeds 255 characters. This would result in an error. ASAP Utilities will now skip cells that are too long and inform you at the end how many cells were skipped because the address was too long.
• Fill » Fill up with leading zeros...
  Once you filled up the numbers with leading zeros the utility didn't always work when you ran the utility on the same data again and wanted less leading zeros. This is now fixed.
• Undo
  Improved, especially on cells with very long values (more than 1024 characters).
• Several improvements and small bugs fixed.

When is ASAP Utilities free and when do you need to purchase 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
• or because you know the money will be invested in further development,
• or if you want to get priority support.

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