Compare versions

Version 8.7.2 compared to version 4.2.0

New tools and improvements:

Export  ›  1. Export selection or active sheet as new file...

Updated the "Open the export in Windows Notepad instead of saving it" option to handle recent changes in Notepad in Windows 11.



General

Made several text improvements for clarity and consistency.

General

We made various small improvements.

Date Picker shortcut: Control+Alt+T

The "Date Picker" calendar popup has been added to the "Favorites & Shortcut Keys" menu and can now be launched using the shortcut Ctrl+Alt+T.





 

Apply Sensitivity labels if required

Sensitivity is available if:
• Your Office account is a work account with an Office 365 Enterprise E3 or Office 365 Enterprise E5 license assigned.
• Your administrator has configured sensitivity labels and published them to you.

# Microsoft: Apply sensitivity labels to your files and email
https://support.microsoft.com/en-us/office/apply-sensitivity-labels-to-your-files-and-email-2f96e7cd-d5a4-403b-8bd7-4cc636bae0f9

If your organization uses Sensitivity labels, then Excel files can only be saved when a sensitivity label is applied.

We updated ASAP Utilities so that the sensitivity label information is copied from the source workbook or you  are asked by Excel to apply a sensitivity label before an Excel workbook is saved in xlsb or xlsx format, or , with the following tools:

• Export  ›  4. Export worksheets as separate files...
• Export  ›  1. Export selection or active sheet as new file...
• File & System  ›  1. Save file and create backup...

NEW: Numbers & Dates  ›  17. Date Picker...

The date picker popup simplifies selecting and inserting dates into your worksheet.

It displays a visual calendar, allowing you to quickly identify and select dates instead of having to type the date manually.

It is handy for quickly finding and entering dates accurately, without errors in format or value.

• Browse by year and month to pick a date.
• Select a date and it automatically inserts it into the active cell.
• If a cell isn't formatted as a date, the Date Picker will insert the picked date and apply the short-date format according to your regional Windows setting.
• The Date Picker popup "floats", so you can easily keep it visible and select the cells to insert a date.
• You can enable the Date Picker to show automatically when double-clicking a date cell. It then appears when you double-click a cell with a date or date format.
• You can choose to have the calendar view start with today’s date (default), or the date of the selected cell.
• You can choose the starting day of the week: Monday, Sunday, or Saturday.
• The calendar shows (ISO) week numbers for easy identification.
• Choose to close the form after date entry or move to the next cell.
• Simply close the Date Picker by pressing the ESC-key or clicking the X in the title bar.


Screenshot 1, week starts on Sunday:


Screenshot 2, week starts on Monday:


Screenshot 3, Settings:


New: =ASAPCELLCOLOR(cell)

Returns the color number of the cell.
This is a number representing the RGB color value.

NEW: =ASAPFONTCOLOR(cell)

Returns the color number of the font of a cell.
This is a number representing the RGB color value.

General

Made a few small improvements.

Text  ›  7. Change Case (with options)...

Improved the "Set words to preserve/exclude" setting. 
In addition to a space, it now also detects separate words based on any of the following characters: . ' ] ) ) { } : [ ( ; "

General

• We made a few small improvements.

ASAP Utilities Options  ›  1. Settings, language and contact information...

Microsoft Office's Visual Basic for Applications (VBA) still does not natively support mouse wheel scrolling in UserForms/dialog boxes.
This has been a request to Microsoft for decades already. Users requested it to us too, and since Microsoft still hasn't implemented it, we investigated and implemented a workaround for this in ASAP Utilities.
You can now enable this via the option: Enable mouse wheel scrolling for dialog boxes



There appears to be a bug in certain Excel 365 builds which currently may cause this new functionality to crash those Excel builds/versions, so be careful when you try it the first time.
To try it, just enable the option, click OK, close the settings window, and then for example choose ASAP Utilities  ›  Info...
If that crashes Excel (sometimes you see a cryptic Microsoft Visual Basic for Applications - Unexpected error (35010), go back to the options and turn off this setting until you have updated your Excel version/build.

Export in JSON format

While Excel can import data in JSON format, it cannot natively save in this format.
Now, with ASAP Utilities, you can export to JSON.

JSON, or JavaScript Object Notation, is a lightweight format for storing and transporting data, often used in web applications for data exchange.

Saving your data in JSON-format has been added to the following tools:

• Export › Export selection or active sheet as new file...
• Export › Export worksheets as separate files...




Import data from copied Word Table without splitting cells at line breaks

Via ASAP Utilities › ASAP Utilities Options › 11. New tools in development (English only)
When you copy a table from Word to Excel, Excel splits cells with line breaks into separate cells.
This tool helps you transfer your table to Excel while maintaining its original structure.

General

Fixed some known issues and made a few small improvements.

General

• Some ribbon icons have been refined to look sharper on displays with a Windows Display Scale setting over 200%.
• All forms in our app now use a modern font, aligning with the one Excel uses.
  This offers a subtle upgrade from the standard font found in xlam add-ins, aiming for a more harmonious user experience.
• We've addressed some known issues and made a few small, yet significant, improvements to enhance your experience. 

Columns & Rows  ›  10. View and manage hidden rows and columns...

The layout has been refined to reveal more information from hidden rows and columns all at once. Additionally, a horizontal scrollbar has been introduced for effortless navigation when row or column headers are too lengthy to display in full.


• We've addressed some known issues and made many small, yet significant, improvements to enhance your experience.
• The localized per language ribbon/menu xlam-files no longer use an API call.
  This is related to the following if your company blocks Win32 API calls from Office macros: https://www.asap-utilities.com/faq-questions-answers-detail.php?m=340
• Range  ›  4. Sort values inside each cell in selection...
  By request, we have added an option to sort in reverse order.
  You can then for example sort first by state and then by city for a cell that includes "City, State".
  

• Range › Sort values inside each cell in selection...
  Now supports the sorting of Unicode text if you have Excel 2021 or Excel 365.
• General
  A few visual improvements.
• Speed
  Improved speed when certain quirks of Excel 365 could have caused delays.
A few small improvements in terms of text and display.

Tip of the day - Discover more features

By request, a daily tip to get to know ASAP Utilities better.

ASAP Utilities contains an incredible amount of small handy tools and it might be hard to remember them all.
Each day we show you a handy tool that you may have forgotten about or never knew existed.


Count duplicates and give each set of duplicates its own color

Improved. Better distinctive colors and use of patterns are used.
This allows now to identify up to 264 sets of duplicated values with unique colors.
(In case more sets of duplicates are found, those remaining sets of duplicates are filled with the same color.)

Find and run a utility...

Upon request you can now toggle between showing the full descriptions or not. The advantage is that the list of tools found is quicker to scroll through without the descriptions.


New worksheet function


=ASAPGETINDENTLEVEL(cell)

Returns the indent level for the cell.
If you afterwards change the indent level in any of the referenced cells, you have to press Control+Alt+F9 to have the formulas recalculated.

Parameters:
# cell = The cell to get the indent level from.

Updated worksheet function

=ASAPEXTRACTNUMBERS(text, optional strip_leading_zeros)

New optional parameter; strip_leading_zeros

If TRUE and the result is a number with one or more leading zeros, then those leading zeros will be removed. Default is FALSE.

Example:
=ASAPEXTRACTNUMBERS("0ADSKP783A") = 0783
=ASAPEXTRACTNUMBERS("0ADSKP783A", FALSE) = 783

Parameters:
# text = The value or cell address from which you want to extract the numbers from.
# keep_leading_zeros = Optional. Preserve leading zeros. If omitted it is assumed to be TRUE.

Support for dynamic array formulas and spilling

The following functions can now also be used in dynamic array formulas and support spilling:

• ASAPCELLCOLORINDEX()
• ASAPCOUNTCHAR()
• ASAPEXTRACTFILENAME()
• ASAPEXTRACTFOLDERNAME()
• ASAPEXTRACTNUMBERS()
• ASAPFONTCOLORINDEX()
• ASAPGETCOMMENT()
• ASAPGETDOMAIN()
• ASAPGETFONTNAME()
• ASAPGETFONTSIZE()
• ASAPGETFORMULA()
• ASAPGETFORMULAINT()
• ASAPGETHYPERLINK()
• ASAPGETINDENTLEVEL
• ASAPGETNUMBERFORMAT()
• ASAPISBOLD()
• ASAPISFORMULA()
• ASAPSPELLNUMBER()
• ASAPSTRIPNUMBERS()


Useful links from Microsoft about Dynamic array formulas:

• Microsoft: Excel functions that return ranges or arrays
  https://support.microsoft.com/en-us/office/excel-functions-that-return-ranges-or-arrays-7d1970e2-cbaa-4279-b59c-b9dd3900fc69
• Microsoft: Dynamic array formulas and spilled array behavior
  https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
• Microsoft: Dynamic array formulas vs. legacy CSE array formulas
  https://support.microsoft.com/en-us/office/dynamic-array-formulas-vs-legacy-cse-array-formulas-ca421f1b-fbb2-4c99-9924-df571bd4f1b4
• Microsoft: Dynamic array formulas in non-dynamic aware Excel
  https://support.microsoft.com/en-us/office/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2

Worksheet functions support conditional applied formatting

The following functions now support/read formatting applied via conditional formatting:

• ASAPCELLCOLORINDEX()
• ASAPCOUNTBYCELLCOLOR()
• ASAPCOUNTBYFONTCOLOR()
• ASAPCOUNTSHADES()
• ASAPFONTCOLORINDEX()
• ASAPISBOLD()
• ASAPSUMBYCELLCOLOR()
• ASAPSUMBYFONTCOLOR

Select all shapes within the selected range

Selects all shapes that are inside or touch the selected range. Both visible and hiddens shapes will be selected.

via ASAP Utilities Options  ›  11. New tools in development (English only)

Clear Pivot Tables cache and refresh

Clears the cache from the pivot tables on the current worksheet or in the entire workbook.

via ASAP Utilities Options  ›  11. New tools in development (English only)

General

• Many (smaller but important) improvements.
• By request; the license info screen now contains a button to remove the license.

Minimum supported Excel version is 2010

Starting from version 8, ASAP Utilities requires at least Excel 2010, but we recommend to use at least Excel 2013 because that is still updated by Microsoft.
For many years already Microsoft no longer supports old Excel versions. By using such an old Excel version you could expose yourself to serious and potentially harmful security risks that may be in those old Excel versions.
Currently the oldest version of Excel that Microsoft still updates is Excel 2013.

General

Several small improvements.

Setup

The option "Add our company  (A Must in Every Office BV) to the list of Trusted Publishers (all users)" is now checked by default.
This is done to help make it easier to use ASAP Utilities with improved security in Excel.
https://docs.microsoft.com/en-us/DeployOffice/security/internet-macros-blocked

We have incorporated our new logo

The new logo, for use on a light background:


The new logo, in white with the orange as background color:

We updated the ASAP Utilities ribbon in Excel with a few improved icons for:

• Favorites & Shortcut keys
• ASAP Utilities Options
• Find and run a utility
• Start last tool again



Learn more about the background and creation of our new logo

General


• Windows 11 and Excel 2021 have been added in the documentation as being supported.

In the universal 32+64-bits edition for Excel 2010-2021/365

• Several small (performance) improvements
• A few small improvements
• A few small improvements

You can now use regular expressions in Excel via ASAP Utilities.

Regular expressions are a clever way to find & replace text (similar to 'wildcards')
Regular expressions are very common in some areas of computing, and are often known as regex or regexp. Not all regex are the same - so reading the below link from Microsoft Docs is recommended.

You can use the regular expression syntax in ASAP Utilities according to the following documentation from Microsoft:
Regular Expression Syntax (Scripting) | Microsoft Docs
https://docs.microsoft.com/en-us/previous-versions//1400241x(v=vs.85)



ASAPREGEXMATCH

Returns TRUE if the value matches the regular expression and FALSE if it does not.

=ASAPREGEXMATCH(read_value, regular_expression, optional ignorecase)

• read_value  The text to be tested against the regular expression.
• regular_expression  The regular expression to test the text against.
• ignorecase  Optional. Specifies case-insensitive matching. If omitted it is assumed to be FALSE.

examples:

value	expression	result	formula
Emmawijk 1	[0-9]+	TRUE	=ASAPREGEXMATCH(A2, B2)
Today's offer is $99.00	[0-9]*\.[0-9]+[0-9]+	TRUE	=ASAPREGEXMATCH(A3, B3)
The appointment is at 15:00	\d{2}\:\d{2}	TRUE	=ASAPREGEXMATCH(A4, B4)

 

ASAPREGEXEXTRACT

Returns the text that matches the regular expression.

=ASAPREGEXEXTRACT(read_value, regular_expression, optional ignorecase)

• read_value  The text to be tested against the regular expression. 
• regular_expression  The regular expression to test the text against.
• ignorecase  Optional. Specifies case-insensitive matching. If omitted it is assumed to be FALSE.

examples:

value	expression	result	formula
Emmawijk 1	[0-9]+	1	=ASAPREGEXEXTRACT(A2, B2)
Today's offer is $99.00	[0-9]*\.[0-9]+[0-9]+	99.00	=ASAPREGEXEXTRACT(A3, B3)
The appointment is at 15:00	\d{2}\:\d{2}	15:00	=ASAPREGEXEXTRACT(A4, B4)

 

ASAPREGEXREPLACE

Returns a modified version of the text string based on a regular expression.

=ASAPREGEXREPLACE(read_value, regular_expression, replacement_value, optional replace_all, optional ignorecase)

• read_value  The text to be tested against the regular expression.
• regular_expression  The regular expression to test the text against.
• replacement_value  The text to replace the matched groups with.
• replace_all  Optional. Specifies to replace all matches. If omitted it is assumed to be TRUE.
• ignorecase  Optional. Specifies case-insensitive matching. If omitted it is assumed to be FALSE.

examples:

value	expression	replacement	result	formula
Emmawijk 1	[0-9]+	200	Emmawijk 200	=ASAPREGEXREPLACE(A2,B2,C2)
Today's offer is $99.00	[0-9]*\.[0-9]+[0-9]+	49.99	Today's offer is $49.99	=ASAPREGEXREPLACE(A3,B3,C3)
The appointment is at 15:00	\d{2}\:\d{2}	10:30	The appointment is at 10:30	=ASAPREGEXREPLACE(A4,B4,C4)
The color is (green)	\(([A-Za-z]+)\)	red	The color is red	=ASAPREGEXREPLACE(A4,B4,C4)

 

New example workbook that demonstrates the ASAP Utilities functions

We have updated the example workbook that demonstrates the extra functions you get in Excel with ASAP Utilities.
You download the example workbook via:
https://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=259&utilities=97&lang=en_us#example-workbook


Select » Select cells based on content, formatting and more...

You can now select cells that match a regular expression, similar to the above ASAPREGEXMATCH function.

A few examples:

pattern	result
^\d	select values that start with a digit character
\d$	select values that end with a digit character
[^\d]$	select values that do not end with a digit character
red|green|blue	select values that contain either red, green or blue
etc etc.	https://docs.microsoft.com/en-us/previous-versions//1400241x(v=vs.85)




Export » Copy selection as values to clipboard

Now supports unicode characters in Windows 10.

Export » Export selection or active sheet as new file...

The options "Copy to clipboard (tab delimited)" and Copy to clipboard (space delimited)", now support unicode characters in Windows 10.

General

Several small improvements.

 

In the universal 32+64-bits edition for Excel 2010-2019/365 only:

New: List all possible combinations from two or more lists/columns

via ASAP Utilities Options » New tools in development (English only)

This will create a list of all possible combinations from the data in two or more columns



New: Delete all empty columns, including the columns that have a field name in row 1, but no data

via ASAP Utilities Options » New tools in development (English only)

This will remove all completely empty columns on your worksheet, including the columns that have a field name in row 1, but no data.



General

• Improved setup
  In a rare situation the setup incorrectly detected Excel 2007 instead of Excel 2010 installed on a system and then only offered to install the 32-bits edition.
  This is now fixed so that you can also install the universal and faster "32+64-bits" edition for Excel 2010 and later.
• Text » Advanced character remove or replace...
  Improved so that it works better when the Windows System Locale option
  "Beta: Use Unicode UTF-8 for worldwide language support" is checked. (Having this option checked changes the result of Excel's =CHAR() function for a language for characters 128-255.)
• General, support for "Beta: Use Unicode UTF-8 for worldwide language support" option
  Several changes so that it works better when the Windows System Locale option
  "Beta: Use Unicode UTF-8 for worldwide language support" is checked.
  When this option is checked, Excel's built-in =CHAR() function gives different results for ASCII characters 128-255 for the same language.
  This option in Windows can be found in the following location:
  Window Start > type "control panel" (without the quotes) in the search box and select Control Panel in the results.
  In the Control Panel with  Clock and Region click on Change date, time and number formats
  Go to the Administrative tab and click Change system locale...
  Here is the  "Beta: Use Unicode UTF-8 for worldwide language support" option.
  By default this is turned off, but some users prefer to have this checked.
  
  
  
• General
  A few small improvements.

In the universal "32+64-bits edition" for Excel 2010 and later only

• ASAP Utilities Ribbon
  The names and descriptions of the tools were displayed but the accented characters in version 7.8 were displayed without their accent (á as a, ë as e, ñ as n etc.).
  This is now fixed.
  

General

• Fill » Create a list of filenames and properties in a folder...
  Now has an option to also report empty folders.
  

• Export » Export worksheets as separate files...
  When exporting text files in unicode format, you can now choose between the standard UTF-16 character coding from Excel, or the commonly used UTF-8 character coding.
  

• Fill » Copy values to empty cells below filled cells in selection
  Since an update to Excel 365 in the summer of 2020, cells with values of more than 255 characters could cause an error when using this tool. Other Excel versions with the latest updates, including Excel 2019 were not impacted.
  However, we've created a workaround so it is working as expected again in all Excel versions.
• Sheets » Split the selected range into multiple worksheets...
  When the sheets were split based on different values in a (sorted) list, the comparison per value was (unintentionally) case-sensitive. This is now fixed, the comparison is no longer case sensitive.
• General: Cisco AMP for Endpoints related Excel crash, followed by Excel asking to disable ASAP Utilities
  Based on extensive communication with a few clients, and the documentation/release notes of Cisco AMP for Endpoints from October 7, 2020, we have made a few small adjustments in ASAP Utilities.
  The new version of Cisco AMP stops Excel when a macro makes certain calls (such as WMI that we used to get the Windows version and wscript that we used to get the user and computer name as part of our anti-fraud system), and in the process of stopping those processes, Cisco AMP just kills/crashes Excel entirely instead of letting Excel or ASAP Utilities give a friendly error message.
  To avoid these crashes by Cisco AMP for Endpoints, we have removed the few triggering code lines in ASAP Utilities and wrote new code that does not use those calls.
  
  We found that Microsoft has already written about the impact that antivirus software can have on Excel:
  # Microsoft: Excel not responding, hangs, freezes or stops working
  “Check to see if your antivirus software is up-to-date or conflicting with Excel”
  https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4
  
  In case ASAP Utilities is disabled by Excel, then follow these steps after you installed this new version:
  1. In Excel, click File, click Options, and then click Add-Ins.
  2. In the Manage list, click Disabled Items, and then click Go.
  3. In the Disabled Items dialog box, select the ASAP Utilities file and then click Enable.
  4. Restart Excel.
• General: Extended Validation (EV) Code Signing Certificate
  Instead of using a standard Code Singing Certificate (to prove our files have not been modified by a third party), our files are now signed with an EV Code Signing Certificate.
  Standard Code Signing Certificates undergo standard organization validation. EV Code Signing Certificates undergo strict Extended Validation vetting requirements set by the CA/B Forum.
  Among added benefits of EV Code Signing certificates is the fact that they provide an instant reputation with Microsoft SmartScreen.
  EV Code Signing also comes with an added layer of security.

Universal 32+64-bit edition only

• NEW: Sheets » Quickly rename multiple sheets at once...
  This tool allows you to quickly rename multiple or all sheets in your workbook at once.
  You can:
  . Use "Find & Replace" in sheet names
  . Insert text before sheet names
  . Insert text after sheet names
  . Automatically generate sheet names from the values in selected cells.
  Via a preview you can see upfront what the new names will become.
  

• Select » Select cells based on content, formatting and more...
  For users with Excel 365 with threaded comments:
  In Excel there is no easy way to quickly identify which threaded comments have been resolved and which ones not. 
  Therefore, by request, we have added two new options in the "Based on formatting and more" tab to quickly select cells with either resolved or unresolved threaded comments:
   . resolved comment thread
   . unresolved comment thread
  When the cells then are selected you can for example given them a color to quickly identify and further process.
  
• General
  A few small improvements based on the feedback from our users.
• New: Write out numbers in French
  Text » Spell/write out numbers or amounts (EN, DE, NL)...
  Has been renamed to "Spell/write out numbers or amounts (EN, DE, FR, NL)..." because the French language is added by request.
  You can now write out numbers/amounts  in French via this tool or by using the =ASAPSPELLNUMBER() worksheet function.
  

In the universal "32+64-bits edition" for Excel 2010 and later only:

• New: Remove duplicated values per row in your selection
  via ASAP Utilities Options » New tools in development (English only)
  "Remove duplicated values per row in your selection"
  This will remove the duplicated values per row in your selection.
  
• New: Quickly rename sheets multiple sheets at once
  via ASAP Utilities Options » New tools in development (English only):
  "Rename sheets"
  This allows you to quickly change the names of multiple or all sheets in your workbook at once.
  You can choose to add text at the en of the name of each sheet, add it at the front, perform a find & replace on the sheet names or name the sheets based on the values in a range.
  
  
  
• =ASAPGETCOMMENT(cell)
  This function now also returns the content of the new Excel 365 threaded comments when used.
  In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
  (Microsoft: The difference between threaded comments and notes)
• Objects & Comments » Comment tools...
  "Extract/report content of comments" now also returns the content of the new Excel 365 threaded comments when used.
  In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
  (Microsoft: The difference between threaded comments and notes)
• General
  A few users got an "Can't find DLL entry point GetTickCount...." error
  That was caused by certain software that blocked access to standard Windows functionality.
  We've got this reported about 5 times, and the information on the following page helped the clients to solve it:
  https://forums.zotero.org/discussion/70171/word-windows-plugin-runtime-error-453
  In that case you may have to add ASAP Utilities to a whitelist in Cylance Protect
  https://threatvector.cylance.com/en_us/home/cylanceprotect-feature-release-macro-script-control.html
  In this new version of ASAP Utilities, we've used a workaround for this Windows timer function and also added some extra error handling to prevent that error from in case blocked.
• General
  Many small improvements, performance improvements and a few bug fixes based on the feedback from our users.
• Columns & Rows » Autofit row height (also on merged cells)
  Much faster speed in certain scenarios.
• Range » Delete all range names in the entire workbook
  Much faster when it involves thousands of named ranges.
• Range » Delete all range names with an invalid cell reference (#REF!)
  Much faster when it involves thousands of named ranges.
• Format » Remove all unused styles on every sheet
  Much faster and better in handling large workbooks with hundreds of thousands of cells to investigate and thousands of styles.
• Improved setup
  In case you were only offered to install the 32-bits edition, then the setup has detected an old Excel version on your system and defaults to the 32-bits edition.
  In this new version, we have changed this so that in case the setup detects both a 64-bits edition of Excel and an old 32-bits edition of Excel on the same system, the default type to install will be the universal and faster "32+64-bits" edition for Excel 2010 and later.
• General
  Several few small improvements, and a few text corrections and bug fixes.
• Format » Clean data and formatting...
  - Improved speed.
  - In case of a filtered list, hidden cells will now be skipped (just like Excel does when editing or formatting cells in a filtered list).

Improved in the "32+64-bit edition"

• Select » Select cells based on content, formatting and more...
  The "expand selection" didn't work in version 7.6. This is now fixed in version 7.6.1.
• General
  Several few small improvements and bug fixes.
• Sheets » Reset Excel's last cell
  Improved performance when it involves many (thousands of) excess columns.
• Information » Fast calculation on selected cells...
  The calculation is now done on only the visible cells in your selection.
  This is useful if you use it on a filtered table.

Improved in the universal "32+64-bit edition" for Excel 2010 and later:

Huge speed improvement when handling duplicates. Especially when using it on a larger range, such as with 2.500-250.000 cells you will see a 25-100× speed increase in the following tools:

• Range » Clear duplicated values in selection (leave one original)
• Range » Count and/or color duplicates in selection...
• Range » Count duplicates and give each set of duplicates its own color
• Information » Fast calculation on selected cells...
• Select » Select cells based on content, formatting and more...
• Select » Conditional row and column select, hide or delete...

The benefit of ASAP Utilities compared to Excel when handling duplicates

ASAP Utilities does not have the limitations that Excel has:

• Excel can't see if it is a duplicate value if the cell's content has more than 255 characters.
• Excel looks only at the first 15 digits in numbers to see if it is a duplicate.
• ASAP Utilities does not have those limitations.
• General
  Improved installer; In a few rare situations the setup didn't correctly detect if you had the 32-bit edition of Excel 2010 or later installed and did not offer you the option to choose between the "32-Bit Edition" and the recommended and faster universal "32+64-Bit Edition.
  
• General
  A few small improvements
• See what else is new in version 7.5
  
• General
  A few small improvements based on feedback from the past weeks.
• Setup
  Improved: In case a user runs the setup with elevated privileges and at step 7 of the setup, he/she chooses to automatically add ASAP Utilities to the Excel menu for all users, then that user no longer has to log off/log in in order to see ASAP Utilities added/updated in Excel.
  Other users on the system will see ASAP Utilities updated in the Excel menu when they (re)login after the setup has been completed.
  
  If you want the ASAP Utilities menu to be automatically added in Excel for all users on this computer choose "Anyone who uses this computer (all users)".
  This will automatically add ASAP Utilities to the Excel menu for each user that logs in on the computer. This is also handy when you log in with normal user-rights and run the setup as an administrator.The "32+64-Bit Edition":
  When upgrading from an earlier 7.x version of ASAP Utilities:
  During the setup of version 7.5, when choosing "Add ASAP Utilities automatically to the Excel menu for anyone who uses this computer (all users)", the setup didn't trigger for the other users to update the Excel setting that stored the filename of our add-in (from "ASAP Utilities x64.xlam" to "ASAP Utilities.xlam"). This is corrected in version 7.5.1

  By default, the "32+64-Bit Edition" will now be recommended on systems with the 32-bits edition of Excel 2010 and later.
  The "32+64-Bit Edition" is the universal version of our add-in (xlam file) that works with both the 32- and 64-bits editions of Excel.
  

  Upon request we've added a new command line parameter that allows system administrators to choose which edition to install: /EDITION
  /EDITION="3264bit"
  Instructs Setup to install the universal 32+64-Bit Edition (xlam files only).
  This edition works with Excel 2010 and later both 32-bit and 64-bit editions.
  /EDITION="32bit"
  Instructs Setup to install the 32-Bit Edition (xlam file and COM add-in/dll file).
  This edition works with the 32-bits editions of Excel 2000 and later.

  Changes in both editions:

  • General
    A few small improvements.
  • Select » Select cells based on content, formatting and more...
    Upon request, six new options are added. You can now select cells based on multiple values at once.
    These values can be in a range of cells in your workbook.
    You can use this for example to select negative keywords in a large dataset.
    1. contains any of the values specified in a range
        searching for "test" selects cells with values such as "This is a test" or "Testing now"
    2. does not contain any of the values specified in a range
        searching for "test" selects cells without the text "test" in it.
    3. contains any of the full words specified in a range
        searching for "test" selects cells with values such as "This is a test" or "Ready (test)"
        searching for "test" does NOT select cells with a value such as "We're testing this"
    4. does not contain any of the full words specified in a range
        searching for "test" does NOT selects cells with values such as "This is a test" or "Ready (test)"
        searching for "test" does select cells with a value such as "We're testing this"
    5. equals a value specified in a range
        searching for "test" selects cells with the value "test" only.
        searching for "test" does NOT select cells with a value such as "test 123"
    6. does not equal a value specified in a range
        searching for "test" does NOT selects cells with the value "test" only.
        searching for "test" selects any cell that has not the same exact content, such as "test 123"
    

  Changes in the "32+64-Bit Edition"

  • General, speed
    Speed improvements. Many tools now run up to 300%(!) faster compared to earlier 7.x versions.
  • General
    The filename of ASAP Utilities has been changed from "ASAP Utilities x64.xlam" to "ASAP Utilities.xlam" to reflect better that this file is not only for the 64-bit edition of Excel but for both the 32- and 64-bit editions of Excel 2010 and later.
    In case you have used one or more of the ASAP Utilities worksheet functions in your workbook, then you might have to update the links to those functions via:
    Formulas » Correct the link to the ASAP Utilities worksheet functions
    

  Both editions:

  • General
    Several small improvements.
  • Export » Export selection or active sheet as new file...
    Export to CSV Unicode, newline character added at the end of the file.
    Better preserving of the Pivot Table formatting when exporting as values.
  • Numbers & Dates » Convert/recognize dates...
    Improved speed
  • Functions =ASAPSUMBYCELLCOLOR() and =ASAPSUMBYFONTCOLOR()
    Cells with logical values (TRUE/FALSE) are now ignored, and cells with a date value are now included too, so that you can also sum dates based on the cell's interior or font color.

  "32+64-bit edition" only:

  • Improved startup speed.
  • General
    A few small improvements.
• Non-admin setup version available of the Business edition
  For users with Excel 2010, 2013 or 2016/365 we have created a special version of  the setup that standard/limited users can install.
  This single-user setup does not require administrator rights during the installation.
• Undo
  Improved performance with complex workbooks.
• General
  Several small improvements.
  Minor text fixes.
  Support for running the setup via the SYSTEM account.

Added support for 64-bits Excel

ASAP Utilities is now also optimized for and works with the 64-bit editions of Excel 2010, Excel 2013 and Excel 2016.

More languages to choose from

To help users whose native language is not English, we've added 5 new languages. You can now choose from 10 languages for the ASAP Utilities user interface.

These 5 new languages for the user interface have been added:

1. Chinese (Simplified) / 中文(简体)
2. Russian / Русский
3. Portuguese (Brazil) / Português do Brasil
4. Italian / Italiano
5. Japanese / 日本語)

Chinese (Simplified) / 中文(简体)

All the tools are now also available in the Chinese language (中文(简体)).
If you have the Chinese version of Excel, then on a new installation ASAP Utilities starts in Chinese
You can also change the language in the options dialogue:
ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
ASAP Utilities » ASAP Utilities 选项 » 设置、语言和联系信息...

Russian / Русский

All the tools are now also available in the Russian language (Русский).
If you have the Russian version of Excel, then on a new installation ASAP Utilities starts in Russian.
You can also change the language in the options dialogue:
ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
ASAP Utilities » Параметры ASAP Utilities » Параметры, язык и контактная информация...

Portuguese (Brazil) / Português do Brasil

All the tools are now also available in the Portuguese language (Português do Brasil).
If you have the Portuguese version of Excel, then on a new installation ASAP Utilities starts in Portuguese
You can also change the language in the options dialogue:
ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
ASAP Utilities » ASAP Utilities Opções » Definições, linguagem e informações de contato...

Italian /Italiano

All the tools are now also available in the Italian language (Italiano).
If you have the Italian version of Excel, then on a new installation ASAP Utilities starts in Italian.
You can also change the language in the options dialogue:
ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
ASAP Utilities » Opzioni ASAP Utilities » Impostazioni, lingua e informazioni di contatto...

Japanese / 日本語

All the tools are now also available in the Japanese language (日本語).
If you have the Japanese version of Excel, then on a new installation ASAP Utilities starts in Japanese.
You can also change the language in the options dialogue:
ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
ASAP Utilities » ASAP Utilities オプション » 設定、言語、連絡先情報...

General

Several improvements compared to ASAP Utilities 5.6

Export » Export worksheets as separate files...
By request the following file formats have been added:
- Text (Delimited by tilde '~') (*.txt)
- Text unicode (Delimited by tilde '~') (*.txt)

NEW: Text » Subscript the numbers in Chemical Formulas
This will subscript the numbers in chemical notations such as C8H10N4O2, Al(OH)3, AlF6Li3, AlO2, Al(NO3)3, Au2(SeO4)3, Ca(VO4)2, H6TeO6, KAlMg3Si3O12H2, Ca(NO3)2 · 4H2O, etc.
It automatically detects which numbers should be subscripted.

Export » Export selection or active sheet as new file...
You can now choose the Unicode encoding for the CSV/delimited text file format:
- Unicode (UTF-16LE)
- UTF-8

Improved: Import » Insert (delimited) text file...
You can now choose the "File origin":
- Windows (ANSI)
- 65001 Unicode (UTF-8)
(previously Windows (ANSI) was always used)

Select » Select cells based on content, formatting and more...
We've added two new options. This allows you to select cells with values that are in all lowercase or all uppercase.
- values in lowercase
- values in UPPERCASE

Improved: Import » Merge and/or import multiple files...
You can now choose the "File origin", for example to choose if the file is in Windows (ANSI) mode or for example UTF-8 and many more.
Up until now, Windows (ANSI) was always used by this tool.

Range » Copy selection and paste into only the visible cells...

Now also copies only the visible cells from the source too.
This tool copies the visible cells in your current selection and then pastes these into only the visible cells in a given destination range.
If there are hidden rows or columns in either the source or the target range, then those will be skipped. The data will then be pasted into the first next visible row or column.
This tool can be useful when pasting data into a filtered list.

ASAP Utilities Right-click context menu

By default tools from ASAP Utilities are shown in the right-click context menu. In this updated version you can, if required, turn it off via the option "Show in right-click context menu (recommended)" in: ASAP Utilities Options » Settings, language and contact information...


Example of the right-click context menu with ASAP Utilities, when you right-click on a cell:

NEW: Range » Sort values inside each cell in selection...

This tool sorts the contents of each cell in your selection.
You can choose if the cell contents are:

• Separated by a space
• Separated by a comma
• Separated by a comma + space
• Separated by a line break (Alt+Enter)
• Or enter your own separator

You can sort either ascending (A-Z) or descending (Z-A)

Tip: You can also use this on a (temporary) extra column in preparation to identify duplicate cell values that consist of multiple values.

NEW: Information » Count duplicates and give each set of duplicates its own color

This tool counts and colors the duplicate values in your selection.
Each set of duplicated values is given its own unique color.

This helps to quickly find the duplicated values, by having a set of colors each of which can readily be distinguished from one another.

Example:
If your selection contains 5 cells with the value "London" then those 5 cells will all get the same color, for example blue. And if the value "Paris" exists in 3 cells then those 3 cells will also get the same, but a different color, such as green.

Remark:
The utility is case sensitive which means for example that "Excel" and "EXCEL" are not the same.
If your selection contains formulas then this utility compares the calculated values. This means that this utility considers a cell with the value 12 and a cell with the formula =3*4 as a duplicate.

NEW: » Text » Change Case (with options)...

This tool changes the text in the selected cells to uppercase, lowercase or other common capitalizations.
You can change the text in selected cells to:

• lowercase
• UPPERCASE
• tOGGLE cASE
• Sentence case
  (first letter of each sentence in uppercase)
• Glossary case
  (first letter of each sentence in lowercase)
• Capitalize Each Word
  Optionally make the first letter of each word uppercase, and the rest of the word lower case.
  And if required you can specify the characters (in addition to a space) that indicate that a new word starts.

Options:

• Choose to preserve all capitalized text (useful in converting glossaries with abbreviations).
  
• Set words to preserve/exclude.

NEW: Range » Copy selection and paste into only the visible cells...

This tool copies your current selection and then pastes the cells into only the visible cells in a given destination range.
If there are hidden rows or columns in the target range, then those will be skipped. The data will then be pasted into the first next visible row or column.
This tool can be useful when pasting data into a filtered list.
Added by user request:
"I want the ability to copy a sequential number of rows from one spreadsheet into another spreadsheet which is full of hidden rows, but I only want my rows to paste into the visible rows (without pasting into any hidden rows). Is there a way within ASAP?"

NEW: Format » Replace conditional formatting with static formatting in selection

This tool replaces the conditional formatting in the selected cells with regular (static) formatting.
The formatting, that has been applied via conditional formatting rules (number, font, border and fill) is verified and then applied as regular (static) formatting.
The conditional formatting rules are then removed, but not the effects.

A practical example:  
'We work a lot with conditional formatting, but our client wants us to "freeze" the format (which means no more use of conditional formatting...) in order to have a classical Excel format (mainly cell and font colors). The idea is to do the same thing as we can do with formulas or calculations "copy > paste as values" but for conditional formatting.'

Note:
This tool works in all Excel versions except for Excel 2007.
Data Bars and Icon Sets cannot be made static with this tool.

NEW: Right click menu

The most popular tools added are added to the right-click/context menu for:

• cells
• column headings
• row number
• sheet tabs

Sheets context menu with ASAP Utilities added:

Improved: Export » Export selection or active sheet as new file...

You can now choose Unicode for the (CSV) delimited text file format.

Improved: Export » Export worksheets as separate files...

New Unicode text file formats have been added:

• CSV unicode  (Comma delimited) (*.csv)
• Text unicode (Delimited by semicolon ';') (*.txt)
• Text unicode (Pipe delimited) (*.txt)

Improved: File & System » Find and remove external links...

Now has a button to report the found links:
"Create a workbook with these results".
 

Improved: Export » Export selected chart or range as image (file)...

New: Export with increased size. You can set the scale for the image from 100% to 500%.

Improved: Sheets » Split the selected range into multiple worksheets...

You can now specify to use a certain worksheet as a source/template sheet instead of only a new blank worksheet.

• First cell of destination range, you can specify the target address of where the data should be copied too (top-left cell of the target range).
• Insert Rows, allows you to insert the data as new rows. Can be useful with templates.
• Keep Source Formatting, copies everything, if you uncheck this option then it copies only the values to the new worksheets.

Added by user request:
"It would be great if you could expand a bit on the "Split Selected Range into Multiple Worksheets" feature. The feature works well right now, but I would love it if I could select a template sheet to be used when creating the new sheets (based off of the values in the specified column) instead of just splitting the worksheet into new plain blank worksheets. And with that, it would be useful if I could specify a
  cell or row range within the template in which I would like the data to be copied."

Improved: Favorites & Shortcut keys » Edit your favorite tools and shortcut keys...

Change of default shortcuts for the following tools:

• Ctrl+Alt+K is replaced by: Ctrl+Alt+Right Arrow - Extend selection to the last used column
• Ctrl+Alt+L is replaced by: Ctrl+Alt+Down Arrow - Extend selection to the last used row
• Ctrl+Alt+V is replaced by: Ctrl+Shift+V  - Vision Control...

When we started with ASAP Utilities in 1998 these 3 shortcuts/key combinations were not used by Excel.
However, since Excel 2007, Excel uses the following shortcuts itself; Ctrl+Alt+L (Reapply Filter) and Ctrl+Alt+V (Paste Special dialog). Therefore we have changed these ASAP Utilities shortcuts to new ones.
If you are upgrading then you need to press the "Reset to default values" button to have this changed, or you can manually make the changes if required:
ASAP Utilities » ASAP Utilities Options » Edit your favorite tools and shortcut keys...

Improved: Bulk replace: replace multiple values at once

via ASAP Utilities Options » New tools in development (English only)

The layout has been simplified and your last used settings are now remembered. Furthermore, the range with these search and replace values will now always be excluded from the target range.
You can specify a range with 2 columns with search and replace values, which allows you to do many replacements automatically after each other. The target can be a certain range, your current worksheet, all selected worksheets, the entire workbook or any other workbook that is opened.

NEW: Detect adjacent row/column data and merge cells...

via ASAP Utilities Options » New tools in development (English only)

This tool detects adjacent cells with the same value and merges those cells into a single merged cell using Excel's merge.
You can choose to:

• merge cells vertically, per column, merge cells with the same value below it
• merge cells horizontally, per row, merge cells with the same value next to it
• set the alignment
• add borders

Useful for quick styling of tables for presentation purposes.

New: Keep or delete certain Rich Text formatted characters...

via ASAP Utilities Options » New tools in development (English only)

This tool allows you to keep or delete the characters inside the cells in your selection that have a certain formatting applied (* Rich text formatting).
You can choose to either keep or delete bold charters, italic characters, strikethrough characters, single underline characters, double underlined characters or normal characters within each cell in your selection.
(* Rich text formatting is a combination of font, font size, font style (for example, bold or italic) and underlining formatting in a single cell.)

New: Text to Columns based on in-cell formatting changes (split by bold, italic, color etc.)

via ASAP Utilities Options » New tools in development (English only)

This tool allows you to split the values inside the cells into separate columns, based on a change in the applied formatting (* Rich text formatting).
It is a similar to Excel's Data > Text to Columns, however in this case the splitting is done based on changes in the applied formatting.
For example, cell with the value "Drum [in bold] Tambour [normal] (f) [italic]" is then split into three columns; Bold, Tambour, (f)
(* Rich text formatting is a combination of font, font size, font style (for example, bold or italic) and underlining formatting in a single cell.)

NEW: Change cells to MAC Address formatting...

via ASAP Utilities Options » New tools in development (English only)

This will change the MAC addresses (such as 0123456789ab) in your selected cells into a more readable and standardized format.
You can choose between the following styles:

• 01:23:45:67:89:ab
• 01-23-45-67-89-ab
• 0123.4567.89ab

The utility will if required automatically remove any spaces, hyphens (-), colons (:) or points(.) so that you can also easily convert it from one format to another.

Added by user request:
"It would be great if you had a way to format a cell (or column or row, or whatever) so that when you enter or paste in a MAC Address, that it would automagically reformat. For example, if I paste in 000c4231f617, it would auto-format to 00:0c:42:31:f6:17."

Some technical background on what a MAC address is:
A MAC (Media Access Control) address is a hardware identification number that uniquely identifies each device on a network.
A MAC address, sometimes referred to as a hardware address or physical address, is a unique identifier that's assigned to a network adapter or any device with built-in networking capability, such as a printer. While an IP address can potentially be assigned to any device, a MAC address is "burned into" a device from the factory and therefore cannot be changed.
If assigned by the manufacturer, a MAC address usually encodes the manufacturer's registered identification number and may be referred to as the burned-in address (BIA). It may also be known as an Ethernet hardware address (EHA), hardware address or physical address.
The standard (IEEE 802) format for printing MAC-48 addresses in human-friendly form is six groups of two hexadecimal digits, separated by hyphens (-) or colons (:), in transmission order (e.g. 01-23-45-67-89-ab   or   01:23:45:67:89:ab ). This form is also commonly used for EUI-64. Another convention used by networking equipment uses three groups of four hexadecimal digits separated by dots (.) (e.g. 0123.4567.89ab ). (http://en.wikipedia.org/wiki/MAC_address)

Format » Detect and visualize adjacent data/group changes...
New: You can now specify the line color for the border.
And you can choose to remove any existing horizontal borders upfront.

Range » Advanced sorting...
We've added a new sort option: "Value, ignore minus sign (-) in numbers"
This will sort your numbers ignoring the negative sign.
Positives and negatives are sorted as the same, which can be helpful for reconciliation (accounting).
For example this allows you to sort your amounts like this:
   -668.00
    668.00
   -995.00
    995.00
  -1187.00
   1187.00
   1657,00
  -1741.00
   1741.00

Range » Advanced sorting...
We've added a new sort option: "Reverse order"
This will reverse the order of the data, independent of the values in the cells.
You can use it to flip entire rows vertically or columns horizontally.
This can be helpful in for example the following scenario:
I've a long column of numbers in excel which I need to flip around or invert. I can't use Excel's sort function as it only sorts it in ascending or descending order but I need to reverse the order of the numbers
so that bottom becomes top and top becomes bottom for example.

NEW: Count and color unique duplicate values
via ASAP Utilities Options » New tools in development (English only)
Count and color the duplicate values in your selection where each set of duplications gets its own color.
(As long as there are enough distinct colors available to see the difference. If there are too many sets of duplicates then you will be notified).

NEW: Insert a space before Capital Letters (e.g. 'BigBearLake' > 'Big Bear Lake')
via ASAP Utilities Options » New tools in development (English only)
This will put a space in front of Capital letters in the text in your selected cells.
For example "NewYork" becomes "New York".
This tool is smart enough to detect when a space should be inserted and when not.
A space is only inserted before uppercase characters when it is not already preceded by a space and also when it is not preceded by any of the following characters: - " ' ( | = ` [ { < “ ‘

Import » Merge and/or import multiple files...
New option to choose if the data should be copied/pasted as 'values' or 'formulas'.
If you choose 'formulas' then any formulas will be copied as they are, just like a regular 'copy and paste'. This has been how it always was in this tool, before you could make this choice.
If you choose 'values' then the values will be used from your source data, similar to Copy > Paste special > Values
New option to choose if you create a new worksheet for each file: 'Import page and print settings'
 

Text » Replace accented characters (á, ë, ñ etc.)...
Greek accented characters have been added.

Web » Decode all URL and HTML encoded text
Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).

Setup, Trusted Publishers
During the setup you can now have our company (A Must in Every Office BV) automatically added to the List of Trusted Publishers in Excel.
Some people have their security settings set to only allow macros run by Trusted Publishers, and then this can help.
For reference, Microsoft: Add, remove, or view a trusted publisher

Official support for Excel 2013 (32-bit edition of Excel 2013 on both 32- and 64-bit Windows)
ASAP Utilities now works with:
. Excel 2013 (32-bit version)
. Excel 2010 (32-bit version)
. Excel 2007
. Excel 2003
. Excel 2002/XP
. Excel 2000
. On both 32- and 64-bit Windows, including the new Windows 8.

Web » Clean information that is copied from websites...
has been renamed to
Web » Clean data and formatting...
and this utility has also been placed in the Format, Text and Numbers & Dates submenus

Export » Export selection or active sheet as new file...
If you have Excel 2007 or newer you can now choose from:
. Excel 97-2003 Workbook (*.xls)
. Excel Workbook (*.xlsx)
. Excel Binary Workbook (*.xlsb)
(instead of just 'Excel workbook')

Export » Export worksheets as separate files...
When choosing to export as Excel workbooks you can now also choose to export just the values.

Updated User Guide

General, display
The dialog boxes have all been verified and adjusted to scale properly if you have set your text display in Windows set to Medium - 125% or Large - 150%

Select » Select cells based on content, formatting and more...
Massive speed improvement due to a new developed algorithm.

NEW: Range » Paste values only
This will paste the copied data as values only.
You can assign your own shortcut to this via the "Favorites & Shortcuts" menu, such as for example Control+Shift+V.
This tool can speed things up when you use this often and save you a few strokes/mouse actions compared to the "Edit > Paste special > Values" via the menu in Excel when you assign a shortcut to it. .

Objects & Comments » Add cell's value or formula to comment...
This tool add's the cell's value or formula as comment.
You can choose to add new comments, replace existing comments or add the cell's value at the beginning or the end of an existing comment.
You can use to use the cell's value or formula as text for the comment.
By using "Offset" you can specify to read the value of the current cell or a cell to the left or right from it.

Formulas » Report the formulas used in the worksheets in your workbook
This tool will report with all formulas used in the worksheets on your workbook.
The report shows the following information:
- Workbook path and name
- Sheet; The name of the worksheet the formula is on
- Cell; The cell address the formula is in. You can click on the address to jump to it, it is a hyperlink.
- Value; The calculated result
- Displayed value; The displayed result
- Formula; The formula

Web » Remove all HTML tags in the selected cells...
This tool will strip all html tags in the selected cells, such as for example <BR>, <P>, <FONT size=+0>, <SCRIPT>, etc..
You can choose to:
- Keep existing line breaks
- Add line breaks at the end of tags such as <br/>, <p/>, </h1> etc..
In addition it will also convert encoded characters such as &nbsp; and &amp; to normal characters.

IMPROVED: Fill » Create a list of filenames and properties in a folder...
You can now choose to include many additional file details to display, just like in Windows Explorer.
This way you can for example include the album and artist information from your music collection or information from your photos such as width and height, ISO speed ratings, F-stop, etc. etc.
The available fields depend on your Windows version. ASAP Utilities relies on Windows for the details to display.


Example with detailed information from photos:


Example with detailed information from music files:

System » Save file and create backup
You can now choose to create a backup copy in either your backup folder, or in the same folder as your workbook.

Export » Export worksheets as separate files...
Added new export formats:
. Web Page (*.htm, *.html)
. Single File Web Page (*.mht, *.mhtml) (only with Excel 2002/XP, 2003, 2007 and 2010)
. PDF (*.pdf) (only with Excel 2010 and Excel 2007 SP2 or Excel 2007 SP1 with the MS PDF plugin installed)

New worksheet functions:
=ASAPFILEPROPERTIES(property_name_or_id)
Returns the value of one of the built-in document properties for the current workbook.
You can refer to document properties either by index value or by their English name.
The following list shows the available built-in document property names:
1 Title
2 Subject
3 Author
4 Keywords
5 Comments
6 Template
7 Last Author
8 Revision Number
9 Application Name
10 Last Print Date
11 Creation Date
12 Last Save Time
13 Total Editing Time *
14 Number of Pages *
15 Number of Words *
16 Number of Characters *
17 Security
18 Category
19 Format
20 Manager
21 Company
22 Number of Bytes *
23 Number of Lines *
24 Number of Paragraphs *
25 Number of Slides *
26 Number of Notes *
27 Number of Hidden Slides *
28 Number of Multimedia Clips *
29 Hyperlink Base
30 Number of Characters (with spaces) *
* Excel isn't required to define values for every built-in document property.
If Microsoft Excel doesn't define a value for one of the built-in document properties, reading the Value property for that document property results in an error.

=ASAPLOADIMAGE(image_fullname, optional width_in_pixels, optional height_in_pixels)
Inserts the specified image as an object and puts it at the left-top of your cell.
To update the image, you can replace the formula with a new image name.
To remove the image you have to remove both the formula and the image. (The image isn't removed if only the formula is removed.)
Example:
=ASAPLOADIMAGE("D:productsimagesart782.gif")
Parameters:
# image_fullname = The full path and file name of an image of the type that Excel supports
# width_in_pixels = Optional. You can specify the width pixels. If omitted, the width will be proportionally based on the image's height
# height_in_pixels = Optional. You can specify the height in pixels. If omitted, the height will be the height of the cell the formula is in.

Text » Replace accented characters (á, ë, ñ etc.)...
Several characters are added.
If you've used this utility before then you may have to press the "Reset" button in order to see these new characters added.

Undo
New performance setting:
To speed things up you can now choose to disable the undo when your action involves a filtered list and more than a specified amount or rows. By default this option is turned on and the undo will only be available in a filtered list when your sheet involves less than 25000 rows.

Filters and AutoFilters: Mimic Excel's behavior
Excel skips certain operations on hidden cells (cells in hidden rows or columns) if your worksheet contains filtered data (a Filter or AutoFilter). For example if you select range A1:A10 and rows 2 till 9 are hidden and you apply a color, then the color is only applied to the visible cells (A1 and A10).
However, Excel only skips these cells if your worksheet has and autofilter, otherwise the color is applied to both the visible and the hidden cells.
ASAP Utilities now mimics that behavior. If your worksheet contains a Filter or AutoFilter and your selection contains hidden cells, then these hidden cells are skipped by the following tools:
. Activate hyperlinks (create from cell values)...
. Advanced character remove or replace...
. Apply standard format to selected cells
. Change formula reference style (e.g. A1 to $A1 etc.)...
. Change negative numbers to positive and vice versa...
. Change not recognized numbers (text?) to numbers
. Change to lowercase
. Change to UPPERcase
. Change values to text values (adding ' in front)
. Convert percentages to numbers (e.g. 5% to 5)
. Convert/recognize dates...
. Copy values to empty cells below filled cells in selection
. Decode all URL and HTML encoded text
. Delete all after a given number of characters...
. Delete all numbers in selection
. Delete all text characters (a-z) in selected cells
. Delete leading and trailing spaces
. Delete leading, trailing and excessive spaces
. Delete number of ending characters...
. Delete number of leading characters...
. Extract hyperlinks...
. Fill cells with their formatted value
. Fill empty cells in selection...
. Fill up with leading zeros...
. Make first character Uppercase, the rest lowercase
. Make last character subscript
. Make last character superscript
. Move minus sign from back to front (e.g. 65- to -65)
. Overwrite filled cells in selection...
. Quick numbering of selected cells...
. Rebuild array formulas
. Remove all hyperlinks in selected cells
. Remove ending carriage return (alt+enter character)
. Replace accented characters (á, ë, ñ etc.)...
. Reverse text in selected cells
. Round numbers (not formatting, but changing)...
. Spell/write out numbers or amounts (EN, DE, NL)...
. Start Each Word With Uppercase
. Start first word with Uppercase
. Unwrap text
. Use a significant number of decimals...
. Wrap text
. New: Add cell's value or formula to comment
. New: Change text case (with options)
. New: Change julian dates to normal dates in selected cells
. New: Subscript the numbers in chemical equations
. New: Change conditional formatting to static formatting
For your information, in previous versions of ASAP Utilities, you had to first use Excel to selected only the visible cells in your selection as a workaround (Excel, F5 > Special... > Visible cells only) if you only wanted the tools to affect the visible cells in your selected range.

ASAP Utilities Options » New tools in development (English only)
The following tools are added by request:
. Change conditional formatting to static formatting
This tool will change the conditional formatting in selected cells to static formatting.
It verifies the formatting that has been applied via conditional formatting (font, color and borders) and then apply that as standard formatting.
Settings of font, color and borders will be applied. Data Bars and Icon Sets cannot be made static with this tool.
This tool only works with Excel 2000, 2000/XP, 2003 and 2010 (Excel 2007 is not supported).
Don't hesitate to experiment with this tool, it has and undo.
A practical example on when this can be useful:  
'We work a lot with conditional formatting (in Excel 2003), but our client wants us to “freeze� the format (Yes, that means no more “conditional�...) in order to have a classical Excel format (mainly cell and font colours).
The idea is to do the same thing as we do with formulas or calculations "copy/paste in value" but for conditional formatting.'

ASAP Utilities Options » New tools in development (English only)
The following tools are added by request:
. Add cell's value or formula to comment
Add the value formula as comment. You can choose replace existing comments or add the value at the beginning of the end of an existing comment.
You can also specify to read the value of a cell to the left or right and use that value or formula as comment.
Don't hesitate to experiment with this tool, it has and undo.

. Insert an apostrophe (') in front of each formula in your selection

Import » Merge and/or import multiple files...
New, when you merge the data you can now choose to have the filename listed in column A.

Columns & Rows » Delete all hidden rows and columns
This utility used to delete all hidden rows and columns together.
You can now choose to either delete all hidden rows, all hidden columns or both.
Between brackets the tool shows how many rows and columns are hidden on your worksheet:
 

Export » Export worksheets as separate files...
Has a new option to choose; "Do not export hidden cells", just like the utility
"Export selection or active sheet as new file..."

We also added the Excel Binary7 Workbook-format (xlsb) if you have Excel 2007 or newer:

ASAP Utilities Options » New tools in development (English only)
By request, the following tools are added:
- Delete range names with bad cell references (#REF!)
Removes all range names with invalid addresses. The utility creates a report that shows which names have been removed.
- Ungroup all grouped columns in the selected worksheets
- Ungroup all grouped rows in the selected worksheets
- Bulk replace: replace multiple values at once
You can specify a range with the values to search for and replace, which allows you to do many replacements automatically after each other. The target can be a certain range, your current worksheet, all selected worksheets, or even an entire workbook (that is open in Excel). At this moment the search/replace is done in cell values and hyperlinks. We're working on more items to search/replace in, such as formulas, comments, header/footer, textboxes, etc.
We think this tool can be a huge time saver. Please let me know what you think of it and if we're missing something.

System » Easily create a lot of folders based on the values in selected cells...
Now supports creating subfolders if a cell value contains a value such as "folder\subfolder1\subfolder2".
Previously the backslash \ in a cell value was changed to an underscore and then the folder was created. Now the backslash is used to create subfolders.

General
In the Windows Start menu, two existing options from ASAP Utilities have been renamed to a less technical sentence:
"install ASAP Utilities as a default add-in in Excel" has been renamed to:
"Add ASAP Utilities to the Excel menu"
"uninstall ASAP Utilities as add-in in Excel" has been renamed to:
"Remove ASAP Utilities from the Excel menu"

Example workbook for the extra worksheet functions that you get with ASAP Utilities.
We have created a example workbook that shows how to get things done, that are normally not possible in Excel, by using the functions that ASAP Utilities adds.
Download "Example-workbook-ASAP-Utilities-formulas.xls".

Favorites & Shortcuts » Organize your favorite tools...
New option: Create a list of all shortcuts
This allows you to print out a quick reference card/cheat sheet of your favorite tools and the assigned shortcuts that are used by ASAP Utilities.

Format » Detect and visualize adjacent data/group changes...
You can now specify the number of empty rows to insert in between.

NEW: Change text case (with options)
via: ASAP Utilities Options » New tools in development (English only)
In addition to the existing change-case tools, this utility allows exceptions, such as certain abbreviations.

Find and run a utility...
You can quickly add the tool from within the result window to your Favorites-menu by pressing the + button:

NEW: Sheets » Split the selected range into multiple worksheets...
With this tool you can quickly split your data into multiple sheets.
You can do this either by value, for example to create a new sheet for each company, or you can specify the number of rows to create per sheet.
We have also received the request for this tool from people that used workbooks with over 500 000 rows (Excel 2007/2010) and then needed to open the information in Excel 2003. In order to do that they had to split the information into pieces of a max of 65536 rows because that is the maximum amount of rows that a sheet in Excel 2003 can contain. Now, with this tool you can do that much faster.
Note:
Your original worksheet remains unaltered.
If you want to save the new created worksheets as separate files, then you can do this with the utility "Export » Export worksheets as separate files...

Example of the "For every new value/group in column" option. A new sheet is when the brand name in column A changes and that data is copied to the new worksheet:

NEW: Formulas » Replace the range names used in formulas with their cell reference (on selected sheets)
This utility replaces the range names used in the formulas on the selected sheets with their cell references.
For example if you have a value in cell C10 with the range name 'quantity' and you used a formula such as '=A1*quantity', then this utility will replace that formula with '=A1*C10'.

Select the sheets and start the utility:


The range names have been replaced with their cell references.
As you can see, if needed the utility adds the sheetname for the cell reference too if needed:


At the end a report with the changes that were made is presented:

Web » Clean information that is copied from websites...
Now has buttons to quickly check, uncheck or inverse all options.
This utility is handy to quickly clean up data in general.

Subscript the numbers in chemical equations
via: ASAP Utilities Options » New tools in development (English only)
This utility will subscript the numbers in chemical notations such as Al(OH)3, AlF6Li3, AlO2, Al(NO3)3, Au2(SeO4)3, Ca(VO4)2, H6TeO6, KAlMg3Si3O12H2, Ca(NO3)2 Â· 4H2O, etc.
It automatically detects which numbers should be subscripted.

NEW: Report the formulas used in the worksheets in your workbook
via: ASAP Utilities Options » New tools in development (English only)
This utility creates a report that lists all the formulas that are used in the worksheets in your workbook.



You can click on the cell in the report to jump to the cell in the reported workbook:

Functions
In Excel 2003, 2007 and 2010 the ASAP Utilities functions are now listed in Excel's "Insert Function" Wizard in their own category, called "ASAP Utilities". Furthermore, in Excel 2010 each of the function-arguments has a description in Excel's functions-wizard too.

Excel 2003:


Excel 2010:

Web » Clean information that is copied from websites...
The AutoFit column width and row height now have an option to specify a maximum width or height. Especially with columns this is very useful because columns that are too wide are hard to read or mess-up the layout.

NEW: Columns & Rows » Drawing paper
This tool allows you to specify the column width and row height of your cells in centimeters, inches or pixels.
This is helpful if you use the Excel for drawing purposes, such as creating a flowchart or when you design your garden or need to create a floor plan.
It can also be handy for quickly creating square cells.

NEW: System » Save file as... and use the first cell as the suggested filename
This tool will launch Excel's "save as?" dialog and uses the value of the first filled cell on your worksheet as the suggested filename.

General
The setup is now translated into Dutch, German, Spanish and French too.

Objects & Comments » Comment tools...
Your last used settings will now be remembered.
If you choose to autofit/resize all comments, the utility used to use a maximum width of 300 so that you could read the contents without horizontal scrolling. You can now specify your own maximum width. This can be useful if you have a wider screen and when the comment contains many line-breaks.

ASAP Utilities Options » New tools in development (experimental, English only)
has been renamed to:
ASAP Utilities Options » New tools in development (English only)
The design is improved and it now also remembers the last started utility.

NEW: Show indented structure of formula in current cell
via ASAP Utilities Options » New tools in development (experimental, English only)
This is useful when you have a nested formula. It shows the indented structure of your formula. This way you can more easily see if the brackets are placed properly. You can also edit the formula.

NEW: Copy the path and filename of current workbook to clipboard
via ASAP Utilities Options » New tools in development (experimental, English only)
This will put the path and filename of your current workbook to the clipboard. You can then paste it into another application. This can for example be useful if you're working on a file and want to inform a collegue and tell him/her in an email where he/she can find the file.

NEW: Show or hide formatting marks in selected cells
via ASAP Utilities Options » New tools in development (experimental, English only)
With this tool you can make spaces, tabs and linebreaks visible. This can be useful because sometimes characters such as these mess up your lookup formulas.
The following characters are used to show these characters:
? = space
¬ = tab         
¶ = line breaks
This tool changes your data when you choose "Show" but you can quickly switch back to the original when you choose "Hide". Basically the method is quite simple. It replaces spaces, tabs and line-breaks with a unique character. Then the "Hide" option changes these special characters back to spaces, tabs or linebreaks again.
Unfortunately it is not possible to make it work without changing the values like  the hide/show formatting marks in MS Word. However we think that this tool is a useful alternative.

Select » Select cells based on content, formatting and more...
You can now also select cells based on their date:
. between
. not between
. equal to
. not equal to
. greater than
. less than
. greater than or equal to
. less than or equal to
. Weekday (for example select all Mondays)
. Month (for example select all dates in December)
. Year
. Quarter (1st, 2nd, 3rd or 4th quarter)

Text » Convert/recognize dates...
The utility can now also convert dates where the month is written as text.
This means that if someone has entered for example "January 3, 2008" in a cell that this tool can convert it to a proper Excel date. You can then use it for example in your calculations or have the dates sorted properly.
The utility recognizes the months written out in the language you have specified for the dates in Windows (Regional Settings), and it regognizes the languages English, Dutch, German, Spanish and French.

Select » Select cells based on content, formatting and more...
We've added the option to choose between the cell's value, formula or displayed value (formatted text). This way you can for example select all cells with a formula that references to a certain file or sheet, uses a certain range name, etc., etc..

Range » Advanced sorting...
The option to sort from left-to-right is now also implemented. In addition to Excel's standard left-to-right sorting, you can specify in this tool to use a header column.

Select » Select cells based on content, formatting and more...
With the option "text length" you can now instead of just entering a number, also use <, <=, > or >= in front of it. For example to select all cells with a value longer then 255 character you can use '>255'.

ASAP Utilities Options » New tools in development (experimental, English only)
NEW: Unapply range names in selected formulas (back to cell references)
This utility will replace the range names used in formulas with their cell references. For example if you have a value in cell C10 and named it 'quantity' and you used formulas such as '=A1*quantity', then this utility will replace that formula with '=A1*C10'.

ASAP Utilities Options » New tools in development (experimental, English only)
NEW: Split data table into multiple worksheets
With this tool you can quickly split your data into multiple parts on different sheets. You can for example split a large table into multiple sheets.
You can do this either by value, for example to create a new sheet for each company, or you can specify the number of rows to create per sheet.


The result:
 
We have also received the request for this tool from people that used workbooks with over 500 000 rows (Excel 2007) and then needed to open the information in Excel 2003. In order to do that they had to split the information into pieces of a max of 65536 rows because that is the maximum amount of rows that a sheet in Excel 2003 can contain. Now, with this tool you can do that much faster.

ASAP Utilities Options » New tools in development (experimental, English only)
NEW: Set the width and height of cells in centimeters or inches
This can be helpful if you use the Excel for drawing purposes, such as creating  a flowchart or when you design your garden. Or just because you want square cells.

ASAP Utilities Options » New tools in development (experimental, English only)
NEW: Manage duplicated records
With this utility you can easily remove the duplicated records from your sheet.
You can also have it remove records from your sheet that already exist on another sheet, which can for example be useful if you are working with mailing lists.

French Excel 2000, 2002/XP or 2003 with the new ASAP Utilities in its menu


French Excel 2007 with ASAP Utilities in its menu

• Improved undo
• Numbers » Spell/write out numbers or amounts (EN, DE, NL)...
  If you used rupees (Rs, IRs or NRs) the currency would be listed at the front.
  We now do this for the fully written currency "Rupee" as well.
  This will also affect the worksheet function =ASAPSPELLNUMBER()
  For example: =ASAPSPELLNUMBER(2450.25,"EN","TRUE","Rupee","Rupee",,"Paisa","Paisa Only") would produce
  "Two Thousand Four Hundred Fifty Rupee and Twenty Five Paisa"
  but wil now produce:
  "Rupee Two Thousand Four Hundred Fifty and Twenty Five Paisa"

NEW: Spanish language added
All the tools are also available in the Spanish language (Español) now.
If you have the Spanish language of Excel, ASAP Utilities will now start in Spanish. You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
Note: Only ASAP Utilities itself it translated at this moment. The setup is still in English and so is our website.

• General
  All the items in the menus and on the forms now have mnemonics (also refered to as accelerator keys, access keys, hotkeys or sometimes keyboard shortcuts). A lot of the tools already had these, but we have now added it to all of the tools, in all available languages.
  Accelerator keys are key combinations consisting of the letter key pressed along with  the Alt key. This makes it easier to use ASAP Utilities without a mouse. It can also increase the speed of your work and reduce the chances on RSI. Note: you can (and could) also navigate through the options with tab and shift+tab keys and you can always close a form with the ESC key.
  
  The following screenshot shows an example of which keys you can press in combination with the Alt key to activate certain controls:
  
• Information » Fast calculation on selected cells...
  Expanded. This utility showed the number of unique values, which were the values that appeared only once in your selection. We have now updated the utility to show both the unique (distinct) values, and the values that appear only once in the list. For example, with the values 1/1/2/1/3 the unique values are now 3 (1, 2 and 3) and the values that appear only once in the list is 2 (2 and 3).
  
• Sheets » Insert multiple sheets (uses the cell values as sheet names)...
  Improved speed
• Sheets » Create an index page with links to all sheets (clickable)...
  Improved speed. Furthermore you can now use all sort options when you have selected both worksheets and chart sheets.
• Columns Rows » Insert multiple empty rows at once...
  Instead of inserting the rows below your selected range the utility now inserts the rows above your selected range. We have changed this to reflect the default behavior of Excel when you choose in the menu Insert > Row.
• Columns Rows » Insert between empty rows or columns...
  has been renamed to:
  Columns Rows » Insert empty rows or columns in between...
• Four worksheet functions are updated for Excel 2007 and later.
  Before Excel 2007 a workbook could only contain 56 colors. We used the colorindex property of a cell or font for certain functions. Until Excel 2007 this worked perfect.
  However, in Excel 2007 and later this isn't always reliable anymore because the colorindex number can be the same for different colors. Therefore we have now updated the functions that are listed below. If you specify a range for the color instead of a colorindex number then the function work as supposed in Excel 2007 and later.
  =ASAPCELLCOLORINDEX()
  =ASAPCOUNTBYCELLCOLOR()
  =ASAPSUMBYCELLCOLOR()
  =ASAPSUMBYFONTCOLOR()
  For example to sum the cells in range A1:D100 that have the same color as cell A1, you can use the following formula: =ASAPSUMBYCELLCOLOR(A1:D100, A1). The formula will then return the sum of all cells in A1:D100 that have the same fill color as cell A1.
• Text » Replace accented characters (á, ë, ñ etc.)...
  The following characters are added: ấấặắḑėềẽǧįĺỏțųŭўỹ
  If you have used this utility before you have to press the 'reset' button to have these new characters added.
• Fill » Insert before current value...
  The last 20 values you use to insert before or add after will now be remembered. You can either type in a new value or select a previously used value from the list.
• Fill » Insert after current value...
  The last 20 values you use to insert before or add after will now be remembered. You can either type in a new value or select a previously used value from the list.
• System » Resize the Excel window to standard screen resolutions...
  The screen resolutions 1366 x 768 pixels and 1280x720 were added. The 1366 x 768 pixels display resolution is for example used on certain Sony netbooks.  Now you can quickly change Excel to this resolution so that you know how your spreadsheet model will look on such a computer. The resolution 1024 x 600 pixels which is used by most netbooks, such as the ASUS EEE, was already included.
• NEW: ASAP Utilities Options » New tools in development (experimental, English only)
  New tools that are currently in development. These tools are available in the English language only during this experimental phase.
  At this moment these tools are available:
  . Save as... and use the first cell as the suggested filename
  . Report pivot table(s) information
  . Refresh all external data ranges and PivotTable reports
  . Put all data from the worksheet into one single column
  . Change julian dates to normal dates in selected cells
  
  
• German language added
  All the tools are also available in the German language (Deutsch) now. If you have the German language of Excel, ASAP Utilities will now start in German.
  You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » Settings, language and contact information...
  Note: Only ASAP Utilities itself it translated at this moment. The setup is still  in English and so is our website.
• ASAP Utilities Options » Report the estimated time that is saved by ASAP Utilities
  This tool creates a report in a new workbook with in it the tools you have used. It shows how many times you have used those tools and how much time this has approximately saved you.
  You can enter your hourly rate to estimate how much money you have saved. (Only completely executed tools are counted.) There is also a link for each of the reported tools to the description on this website.
  You can also use this report to show friends/colleagues which tools you use the most.
  
• Columns & Rows » Autofit row height (also for merged cells)
  This tool adjusts the rowheight in the selected cells so that you can read or print the entire content of the cells. In addition to the standard functionality in Excel this tool also adjusts the height properly on merged cells (where 'wrap text' is set). (In Excel itself the auto adjusting of the row height often doesn't work properly on merged cells.)
• Text » Advanced character remove or replace...
  Character code 1 and 2 are added so these can be removed or replaced now too.
• Import » Insert Excel file...
  Besides the standard Excel files, you can now also (depending on your Excel version) insert HTML, XML and ODC files.
• Import » Merge and/or import multiple files...
  Besides the standard Excel files, you can now also (depending on your Excel version) insert HTML, XML and ODC files.
• Select » Select cells based on content, formatting and more...
  Instead of selection a source cell, you can now also select cells based on the font size by entering a number (the font size) instead of a reference to a cell where the font size is read from.
• Excel 2010 Protected View
  ASAP Utilities will now show a friendly message when you try to use one of the tools on a document that is openend in "Protected View" in Excel 2010 (technical preview).
  
• Excel 2010 (former Excel 14)
  Although the technical pre-release of Office 2010 (14) is not officially available yet, we have received several questions from people already testing the version of Excel 2010 that was leaked on the Internet.
  ASAP Utilities will now be automatically added to the menu of Excel 2010 during the setup. Furthermore ASAP Utilities has been globally tested in the technical preview of Excel 2010 (32 bit) and everything seems to work correct after a few adjustments. As far as we were able to test, the current 64 bit (leaked) version of Excel doesn't support add-ins yet.
• Text » Advanced character remove or replace...
  You can now use the following codes as replacement values:
  {lf} = line feed (alt+enter/ascii code 10)
  {cr} = carriage return (ASCII code 13)
  {tab} = tab character.
• Objects & Comments » Delete all objects in selected worksheets
  Improved speed.
• Web » Clean information that is copied from websites...
  Improved the speed of the "removing objects/images" part.
• Select » Select cells based on content, formatting and more...
  Two new select options were added. You can now use it to select merged cells or unmerged cells.
• Numbers » Change not recognized numbers (text?) to numbers
  Numbers that have surrounding internet spaces (character 160) will now be  changed to actual numbers too so that Excel recognizes them correctly in your calculations.
• Export » Export selection or active sheet as new file...
  Improved to better reflect the possibility to create a custom separated text file, such as for example a pipe delimited file. If you specify a comma (,) as delimited, the file will be saved as a .csv file. If you specify a different delimiter you can use your own file extension.

• 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:
  
  
• 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).?
• 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:
  
  
• 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:
  
  
• 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...
  
  
• Text » Advanced character removal/replace...
  The form has been slightly redesigned:
  
  
• Text » Replace accented characters (á, ë, ñ etc.)...
  The form has been slightly redesigned:
  
  
• 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...
• 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:
  
  
  
• 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:
  
  
• Objects & Comments » Comment tools...
  The form has been redesigned:
  
  
• Web » Export selection as HTML table to clipboard...
  The form has been redesigned:
  
  
• 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:
  
  
• 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.
  
  
• 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.
  
• 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.
  
• 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.
• 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
• 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...
• 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.
  
• 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.
• 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.
• 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...
• 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.
• 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.
• Text » Replace accented characters (á, ë, ñ etc.)...
  The following characters have been added: ă, ǻ, ĕ, ї, ĩ, ĭ
  If you don't see this characters when you start the utility, you will have to click on the 'Default' button in order to get them.
  
• Objects & Comments » Delete all objects on current worksheet
  This utility can now be used on multiple worksheets and has been renamed to:
  Delete all objects in selected worksheets
  
• ASAP Utilities Options » Start the last used utility again...
  This now is the default 'repeat' action after a tool in ASAP Utilities has been used so that you can also use it from the Excel menu (Edit > Repeat) or with Excel's built-in shortcuts F4 or Control+Y.
  
• 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.
• Fill » Insert before current value...
  Fill » Insert after current value...
  Contains a new option to skip the empty cells in your selection
  
• Formula » Use a significant number of decimals...
  This utility has been moved to the 'numbers' submenu. It is also still listed in the 'Format' submenu.
• Export » Export worksheets as separate files...
  Improved. You can now choose a custom file extension and with some text files you can choose your own field-enclosers and decimal separator.
   
• Range » Find / Replace in all sheets...
  Besides searching within all worksheets (default) you can also choose to only find/replace on the active worksheet or within the selected ranges.
  
• Web » Convert hyperlinks to =HYPERLINK() formulas
  Updated so that it keeps type the hyperlink formatting if set (blue underlined).
• Text » Replace accented vowels (á, ë, etc.)...
  has been renamed to:
  Replace accented characters (á, ë, ñ etc.)...
  The utility now works on all accented characters, both vowels and consonants.
  Furhermore it will automatically detect lower- and uppercase characters.
  
• General
  Several minor improvements
• Export » Export selection or active sheet as new file...
  The default file extension for tab separated files is now tsv instead of txt (tsv stands for tab separated value)
• Export » Export worksheets as separate files...
  The default file extension for tab separated files is now tsv instead of txt (tsv stands for tab separated value)
• Formula » Convert formulas to their values
  Improved so that it now works on filtered data too.
  Normally the utility changes the formulas to their calculated values in all selected cells (hidden or not). If you have selected cells in a filtered list only the visible cells are affected.
• Web » Activate hyperlinks (create from cell values)...
  Improved, you can now choose to use the "regular" hyperlink or to use the =HYPERLINK() formula to create the hyperlinks. The formula-method is preferred for shared workbooks and when it involves a large amount of hyperlinks.
  
• Columns & Rows » Put together rows or columns from several sheets...
  The column width of the original data is now copied too.
• Export » Export selected chart or range as image (file)...
  You can now choose whether you want to have the utility automatically closed after the export is created.
  
• Fill » Insert before current value...
  Fill » Insert after current value...
  You can now choose to skip empty cells in your selection. There is also a 'reset' button added that will clear the insert before and after values and reset the options to their defaults. Because your previous settings are always remembered this can be handy.
  
• Web » Extract hyperlinks...
  Your last used settings are remembered.
• General
  Several minor improvements
• Fill » Add leading zeros...
  has been renamed to:
  Fill » Fill up with leading zeros...
  We think this is a better description of what the utility does; Fill the current value with leading zeros up to the total length you specify. For example if you enter 3, the number 1 becomes 001 and 11 becomes 011. If you enter 6, the number 1 becomes 000001.
• Format » The smart difference...
  has been renamed to
  Format » Detect and visualize adjacent data/group changes
  to better reflect what the utility does
• New worksheetfunction =ASAPISBOLD()
  Returns true of the referenced cell is bold.
• Export » Export worksheets as separate files...
  Improved, you can now specify in which file-format you want to save the sheets.
  If you have Excel 2000, 2002/XP or 2003 you can export the sheets in these formats:
    - Excel 97-2003 Workbook (*.xls)
    - CSV (Comma delimited) (*.csv)
    - Text (Tab delimited) (*.txt)
    - Text (Tab delimited unicode) (*.txt)
    - Text (Space delimited) (*.prn)
    - Text (Pipe delimited) (*.txt)
    - Text (Delimited by #) (*.txt)
    - DBF 4 (dBASE IV) (*.dbf)
    - DBF 3 (dBASE IV) (*.dbf)
  In Excel 2007 you can save the worksheets in the following file formats:
    - Excel 2007 Workbook (*.xlsx)
    - Excel 97-2003 Workbook (*.xls)
    - CSV (Comma delimited) (*.csv)
    - Text (Tab delimited) (*.txt)
    - Text (Tab delimited unicode) (*.txt)
    - Text (Space delimited) (*.prn)
    - Text (Pipe delimited) (*.txt)
    - Text (Delimited by #) (*.txt)
  
• Import » Insert (delimited) text file...
  Improved, the import of pipe-delimited files has been implemented and you can now have the imported data automatically trimmed (remove leading and trailing spaces).
   
• General
  If you install ASAP Utilities you can choose to have it automatically added to the Excel menu for each user that logs in on the computer. This is also handy when you log in with normal user-rights and run the setup as an administrator.
  
• Export » Export selected chart or range as image (file)...
  The dialog will now automatically be closed after the export is completed.
• ASAP Utilities Options » ASAP Utilities options and settings...
  You can now specify to have the menu-items (Categories) numbered too.
  By default this is turned on.
  
  
• Fill » List filenames in folder...
  Added the option to only list files that were created or modified a number of days ago.
  
• Fill » Quick numbering of cells...
  You can now specify how to increment the numbers. This used to be 1 (1,2,3 etc) but now you can enter your own value, for example 5 to icrement from 5 to 10, 15 etc.
   
• Numbers » Round numbers (not formatting, but changing)...
  Improved speed
• Sheets » Add sheets (with the names defined in selected cells)...
  You can now also choose to color the new sheet-tabs based on the cell colors.
  Colored tabs are available since Excel version 2002/XP.
  
  
• Sheets » Sorts all sheets in alphabetical order
  has been improved and renamed to:
  Sheets » Sort all sheets...
  You can specify to sort the sheets alphanumeric (text), numerically (numbers) or by their tab-color. You can also specify to sort the sheets ascending (A-Z) or descending (Z-A).
  To be able to sort by the tab-colors you need at least Excel 2002/XP.
  
• Web » Decode all URL-encoded data
  Decode all URL-encoded data in your cells.
  This will replace the '+' with a space and decode any %## encoding in the cells, which can be handy when you use Excel to analyse website statistics and keyword performance.
  For example this utility will decode data like:
  %22Keyword%2Binfo%2C.%2F~%26ok%3F
  to:
  'Keyword+info,./~&ok?
  URL Encoding is used when placing text in a query string to avoid it being confused with the URL itself. It is normally used when the browser sends form data to a web server. URL Encoding replaces spaces with '+' signs, and unsafe ASCII characters with '%' followed by their hex equivalent.
• General
  Several minor improvements.
  The default location of the favorites menu file is no longer in the program files folder but instead in the user's application data folder.
• Fill » Random numbering of cells (without duplicates)
  Improved speed
• ASAP Utilities Options » (Re) build the ASAP Utilities favorites menu toolbar
  Create or update a toolbar with the buttons/tools from your favorites menu. The toolbar is automatically updated when you change your favorites menu or your shortcuts to the tools from ASAP Utilities
  
• Format » Copy a sheet's page and print settings...
  Slightly improved speed. Furthermore it displays the current printer at the bottom. The speed of changing the page-setup in Excel might depend on the printer you currently have active. I will write more about this...
  
• =ASAPRandomPassword(length, use_symbols)
  This new function will return a strong password which contains of
    - both uppercase and lowercase letters
    - numbers
    - symbols, such as ~ ! @ # $ % ^ & * ( ) [ ] \ / < > : - = + _
  
  lenght:       The length of the password. If omitted the length will be 8 characters. If the length given is less then 8, still a password of 8 characters will be returned.
  use_symbols:  Use symbols in the password. Recommended for strong passwords. If omitted the password will contain symbols (special characters)
  
  Examples of created passwords:
  =asaprandompassword()                        4j:4Js29
  =asaprandompassword(8,FALSE)          dvU57E6u
  =asaprandompassword(8,TRUE)           -\D5t0:3
  =asaprandompassword(14,FALSE)         55GHo1sM85j9Le
  =asaprandompassword(14,TRUE)          89eTgLq\_46woE
  
  This function can be easy if you need a random password, or for example of you are a system administrator and need to create 50 random passwords for new email addresses.
  
• Format » The smart difference...
  Contains a new option to apply colorbanding. Based on the information of data in a column you can have alternate colors to visualize the differences of data-groups.
  
• General
  A few small improvements.