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 (3,8 MB) attached.

Not able to download?

We can send you the new version by email. The file is 1.2 MB
Send your request to: download@asap-utilities.com

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

Buy a license online.
Safe secure and fast

New ASAP Utilities versions released!

Upgrade recommended

Registration

When to register?

• if you use it for commercial purposes (Feel free to try it for 90 days. If you like it, simply purchase a registration key)
• 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

Thank you

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

The new ASAP Utilities 4.1.0

Download ASAP Utilities 4.1.0

New in version 4.1.0

• General
  Improved setup. Better approach for making ASAP Utilities installed as add-in in Excel and better removal upon uninstall.
• Sheets » Summarize rows or columns from several sheets...
  has been renamed to:
  Sheets » Put together rows or columns from several sheets...
• Select » Select cell with maximum value
  has been renamed to
  Select » Select cell with largest number
• Export » Export selection as HTML table to clipboard...
  Added the option to specify an class for the TR-tag. You can also specify alternate use of the class.
• Range » Advanced sorting...
  Two sort-options were added:
  - Day of the week (start on Sunday)
  - Day of the week (start on Monday)
• New worksheet function: =ASAPExtractFilename(FullFilename, optional separator)
  Extracts the file name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFilename(B23) will return "Sort random(shuffle).xls"
• New worksheet function: =ASAPExtractFolderName(FullFilename, optional separator)
  Extracts the folder name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFolderName(B23) will return "D:\User Guide\screenshots"
  
• New worksheet function: =ASAPGetFormula(FormulaCell)
  Returns the formula in a cell in local Excel language. Example: =GEMIDDELDE("A1:B12")
  Returns empty if the cell does not contain a formula
  
• New worksheet function: =ASAPGetFormulaInt(FormulaCell)
  Returns the formula in a cell in international notation. Example: =AVERAGE("A1:B12")
  Returns empty if the cell does not contain a formula
  
• New worksheet function: =ASAPMergeCells(inputrange, delimiter, skipemptycells)
  An easy alterative for the Excel =CONCATENATE() fuction. However the benefit
  of this ASAP Utilities function:
  - you can specify a range, for example A1:G1
  - you only have to specify a delimiter once
  - by default empty cells will be ignored
  
• New worksheet function: =ASAPCountByCellColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain cell color.
  
• New worksheet function: =ASAPCountByFontColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain font color.
  
• New worksheet function: =ASAPGetDomain(vFullURL, Optional bIncludeProtocol)
  Return the domainname from a given url.
  
• Import » Merge files together in a new file...
  Option added for text files whether or not to treat consecutive delimiters as one
  
• Select » Select cell with smallest number
  Select the cell with the smallest number in your selected range. It uses the =MIN() function to determine the smallest value and then selects that particular cell. If there are more cells that have the same minimum value, only the first cell is selected.
• Formula » Apply formula to selected cells...
  Added an option to only apply the formula to non-hidden cells. This is useful in case you have a range with the autofilter used.
• Fill » List filenames in folder...
  Improved. More information is given about the specified files and it the display of various folders and subfolders is more clear now. By default the autofilter is turned on on the list so you can easily make a selection, for example on certain file types.
• Fill » Add leading zeros...
  Added the possibility to add 0 (zero) leading zeros. This changes the number to be displayed without the leading zeros. (The same result can be achieved by using the "Numbers » Convert "textnumbers" to numbers" utility.)
• Select » Conditional select cells...
  Added the options to select unique values.
• Vision Control
  Now always opens expanded, showing the extra options available
• a few small improvements

Bug fixes in version 4.1.0

• Import » Insert Textfile separated by space...
  Didn't import correctly in Excel 2000. It separated the data on each space, in stead of treating multiple spaces (consecutive delimiters) as one.
• Import » Merge multiple files in a new file.
  Fixed: Sometimes produced a runtime error 5 in Excel 2000.
  Fixed: It separated the data on each space in Excel 2000, in stead of treating multiple spaces (consecutive delimiters) as one.
• Select » Conditional select cells...
  Fixed a bug where in some cases the utility didn't find all cells because the option "Expand current selection" was checked but invisible and therefore couldn't be changed. Selecting duplicate values actually selected the unique values in stead of the duplicate once. This is now corrected.
• Range » Custom formula error message...
  Fixed: When you entered a non-numeric value quotes were saved and then doubled.
• Range » Empty duplicates in selection
  Fixed: Didn't properly remove all duplicate values if you range contained cells with errors too. The utility will now skip the cells that contain an error.
• Information » Get active cell's page number
  Fixed: could produce an error on some workbooks wich were created in Excel 97.
  Also changed the spelling of pagenumber to page number
• Sheets » Add sheets (with the names defined in selected cells)...
  Sometimes it produced an incorrect warning that a sheet already existed.
  This is now fixed. Furthermore I have expanded the way the program handles exisiting sheets. If one is found you can choose to continue with the rest of the cells or cancel the operation.
• Formula » Change reference style (e.g. A1 to $A,1 etc.)...
  Fixed a small bug. Your selected range wasn't properly renewed in the form when you started the utility, in stead it displayed the range you last used before.
• Fill » List filenames in folder...
  Fixed some bugs. In some occasions it didn't list all the files and it gave wrong file size information for files larget then 1.5 GB. The utility didn't work in Excel 2007, now it does.
• Fill » Add leading zeros...
  Fixed a bug that caused extra zeros if you ran the utility on the same numbers again.
• Object/comments » Select all objects
  Fixed a bug that sometime prevented it from selecting all objects/shapes
• Export » Export selection or active sheet as new file...
  Fixed a bug that prevented this utility from starting in Excel 2007
• Range » Paste special (with combinations)...
  Fixed some problems with the arethmetic operations in certain combinations.
• General
  Some minor bugfixes and spelling errors.

ASAP Utilities 3.10F for Excel 97

New in version 3.10F for Excel 97

• New worksheet function: =ASAPGetHyperlink(range, optional sNA)
  This function returns the hyperlink from a cell. The hyperlink can be one of the following: . existing file or web page
  . place in your document
  . e-mail address
  You can optionally specify a string value for the sNA, this text will be displayed for cells without hyperlinks. If omitted the formula will give an empty result for cells without hyperlinks.
  Example: =ASAPGETHYPERLINK(A2,"-")
• New worksheet function: ASAPGetFontName(Range)
  Returns the font name from a given cell.
• New worksheet function: ASAPGetFontSize(Range)
  Returns the font size from a given cell.
• New worksheet function: ASAPGetNumberformat(Range)
  Returns the number format from a given cell.
• New worksheet function: ASAPIsFormula(Range)
  Returns true if the given cell contains a formula or an array-formula, otherwise it returns false.
• New worksheet function: =ASAPCountChar(SearchText, SearchValue)
  This function returns the number of times the “SearchValue” occurs in the “SearchText”. This way you can for example count the number of commas in a cell.
  This function is case sensitive.
• New worksheet function: =ASAPExtractFilename(FullFilename, optional separator)
  Extracts the file name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFilename(B23) will return "Sort random(shuffle).xls"
• New worksheet function: =ASAPExtractFolderName(FullFilename, optional separator)
  Extracts the folder name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFolderName(B23) will return "D:\User Guide\screenshots"
• New worksheet function: =ASAPGetFormula(FormulaCell) Returns the formula in a cell in local Excel language. Example: =GEMIDDELDE("A1:B12")
  Returns empty if the cell does not contain a formula
• New worksheet function: =ASAPGetFormulaInt(FormulaCell)
  Returns the formula in a cell in international notation. Example: =AVERAGE("A1:B12")
  Returns empty if the cell does not contain a formula
• New worksheet function: =ASAPMergeCells(inputrange, delimiter, skipemptycells)
  An easy alterative for the Excel =CONCATENATE() fuction. However the benefit of this ASAP Utilities function:
  - you can specify a range, for example A1:G1
  - you only have to specify a delimiter once
  - by default empty cells will be ignored
  
• New worksheet function: =ASAPCountByCellColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain cell color.
• New worksheet function: =ASAPCountByFontColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain font color.
• New worksheet function: =ASAPGetDomain(vFullURL, Optional bIncludeProtocol)
  Return the domainnaam from a given url.