Compare versions
Version 8.6 compared to version 4.2.0
New tools and improvements:
- 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.
- We made a few small improvements.
- Export › Export selection or active sheet as new file...
- Export › Export worksheets as separate files...
- 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.
- 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. - ASAPCELLCOLORINDEX()
- ASAPCOUNTCHAR()
- ASAPEXTRACTFILENAME()
- ASAPEXTRACTFOLDERNAME()
- ASAPEXTRACTNUMBERS()
- ASAPFONTCOLORINDEX()
- ASAPGETCOMMENT()
- ASAPGETDOMAIN()
- ASAPGETFONTNAME()
- ASAPGETFONTSIZE()
- ASAPGETFORMULA()
- ASAPGETFORMULAINT()
- ASAPGETHYPERLINK()
- ASAPGETINDENTLEVEL
- ASAPGETNUMBERFORMAT()
- ASAPISBOLD()
- ASAPISFORMULA()
- ASAPSPELLNUMBER()
- ASAPSTRIPNUMBERS()
- 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 - ASAPCELLCOLORINDEX()
- ASAPCOUNTBYCELLCOLOR()
- ASAPCOUNTBYFONTCOLOR()
- ASAPCOUNTSHADES()
- ASAPFONTCOLORINDEX()
- ASAPISBOLD()
- ASAPSUMBYCELLCOLOR()
- ASAPSUMBYFONTCOLOR
- Many (smaller but important) improvements.
- By request; the license info screen now contains a button to remove the license.
- Windows 11 and Excel 2021 have been added in the documentation as being supported.
- Several small (performance) improvements
- A few small improvements
- A few small improvements
- 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.
- 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.
- 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.
- 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. - 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.
- 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. -
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.
- 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). - 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. - 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...
- 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.1By 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.
- General
- 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.
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.
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
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:
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
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.
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:
Useful links from Microsoft about Dynamic array formulas:
Worksheet functions support conditional applied formatting
The following functions now support/read formatting applied via conditional formatting:
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
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:
Learn more about the background and creation of our new logo
General
In the universal 32+64-bits edition for Excel 2010-2021/365
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)
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)
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)
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
In the universal "32+64-bits edition" for Excel 2010 and later only
General
Universal 32+64-bit edition only
In the universal "32+64-bits edition" for Excel 2010 and later only:
Improved in the "32+64-bit edition"
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:
The benefit of ASAP Utilities compared to Excel when handling duplicates
ASAP Utilities does not have the limitations that Excel has:
Fixed the bug that caused this tool from not working ("Sorry, something unexpected ent wrong at code line 1010...)
This tool now also decodes "&#x.." encoded characters, such as the following:
- Brasília > BrasÃlia
- Tecnológicas > Tecnológicas
- Università > UniversitÃ
Several small improvements and fixes.
The 64-bit edition didn't properly detect that if it was the Home&Student edition that was installed. This is now fixed.
A few small improvements
Fixed a situation that could cause a compile error in ASAP Utilities in some Japanese and Chinese versions of Excel.
Improved. English numbers between 10 and 99 now use a hyphen.
For example, 35 changed from being written as Thirty Five to Thirty-Five.
The decimals in numbers with decimals and without a currency are now written as hundredths in English, German or Dutch.
Fixed a bug in the 32-bit edition; "Sorry, something went wrong at code line 1080..."
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:
- Chinese (Simplified) / 中文(简体)
- Russian / Русский
- Portuguese (Brazil) / Português do Brasil
- Italian / Italiano
- 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
The option 'Character encoding' now encodes more characters into their HTML character entities.
By request the following file formats have been added:
- Text (Delimited by tilde '~') (*.txt)
- Text unicode (Delimited by tilde '~') (*.txt)
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.
You can now choose the Unicode encoding for the CSV/delimited text file format:
- Unicode (UTF-16LE)
- UTF-8
You can now choose the "File origin":
- Windows (ANSI)
- 65001 Unicode (UTF-8)
(previously Windows (ANSI) was always used)
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
via ASAP Utilities Options » New tools in development (English only)
This tool converts (long) HEX values in the selected cells to ASCII text.
For example, it converts
"446f6e277420796f75207468696e6b207468617420457863656c2069732067726561743f"
to "Don't you think that Excel is great?"
It converts sets like the following:
- 446f6e277420796f75207468696e6b207468617420457863656c2069732067726561743f
- 44-6f-6e-27-74-20-79-6f-75-20-74-68-69-6e-6b-20-74-68-61-74-20-45-78-63-65-6c-20-69-73-20-67-72-65-61-74-3f
- 44~6f~6e~27~74~20~79~6f~75~20~74~68~69~6e~6b~20~74~68~61~74~20~45~78~63~65~6c~20~69~73~20~67~72~65~61~74~3f
- 44 6f 6e 27 74 20 79 6f 75 20 74 68 69 6e 6b 20 74 68 61 74 20 45 78 63 65 6c 20 69 73 20 67 72 65 61 74 3f
- 44:6f:6e:27:74:20:79:6f:75:20:74:68:69:6e:6b:20:74:68:61:74:20:45:78:63:65:6c:20:69:73:20:67:72:65:61:74:3f
Change of default shortcuts for the following tools:
Ctrl+Shift+Vis replaced by: Ctrl+Shift+I - Vision Control...
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...
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.
. Better detection if Excel is started in 'embedded' mode. (Such as for example when you edit an embedded Excel table or chart from within Word or Powerpoint.)
. Several small improvements.
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:
Setup
A new version of the Microsoft 'msaddndr.dll' file (version 6.01.9839) is now included in the setup due to a security update by Microsoft.Starting from ASAP Utilities 5.0 we included Microsoft's 'msaddndr.dll' file with version 6.01.9816 in the ASAP Utilities setup. That is based on the recommendation from Microsoft for Office 2013. The reason we did this, is because a part of ASAP Utilities is a COM add-in that is developed in the MS Office Developer Edition. And COM add-ins created with this Developer Edition or with Visual Basic require the Microsoft 'msaddndr.dll' file (AddInDesigner Object Library). This 'msaddndr.dll' file is installed by default when you run the setup of Microsoft Office 2010, 2007, 2003, 2002 or 2000. But it is no longer installed when you run the setup of Microsoft Office 2013. Therefore we've included it in the ASAP Utilities setup per MS instructions. (source: http://support.microsoft.com/kb/2792179)
Earlier this year a security update was released by Microsoft which also contained a new version of this file, msaddndr.dll version 6.01.9839 (source: http://support.microsoft.com/kb/2880971). Therefore the setup now contains this updated version of the file.
General
A few small improvements and spelling corrections.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
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: Text » Convert/recognize dates...
Added the space+comma in the "convert to" options. This allows you to show a date as "May 21, 2014".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+Kis replaced by: Ctrl+Alt+Right Arrow - Extend selection to the last used columnCtrl+Alt+Lis replaced by: Ctrl+Alt+Down Arrow - Extend selection to the last used rowCtrl+Alt+Vis replaced by: Ctrl+Shift+V - Vision Control...
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: function =ASAPSHEETNAME(optional reference)
The function can now be given a range as parameter. That way you can get the name of another sheet instead of the current sheet. If omitted the name of the current sheet is returned.Improved: Columns & Rows » Autofit row height (also on merged cells)
Now adjusts the row height based on the visible cells in the row only.Any hidden columns in your selection will now be skipped (In contrary to Excel's AutoFit which does not exclude hidden columns so the row height is then also based on the values in hidden columns).
Compared to Excel's built-in "AutoFit Row Height", this tool:
- works on merged cells too.
- ignores data in hidden columns for determining the row height.
Improved: Range » Find and/or replace in all sheets...
Now allows a "Find" value of more than 255 characters.(Excel's built-in Find & Replace does not allow search strings of more than 255 characters)
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
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,
(* 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
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)
General
Speed improvements and a few small other improvements and spelling corrections.New: You can now specify the line color for the border.
And you can choose to remove any existing horizontal borders upfront.
A few small improvements.
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
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.
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).
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: - " ' ( | = ` [ { < “ ‘
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'
Greek accented characters have been added.
Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).
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
Customization, add tools to the Ribbon
The tools from ASAP Utilities are now easier to add to the QAT (Quick Access Toolbar) from Excel 2013/2010/2007. Besides the existing way to add them to your favorites menu, we think that this might help to even further speed up your workflow.
You can do on two ways
#Method 1 By right-clicking on a tool in the menu and then choosing "Add to Quick Access Toolbar":
#Method 2 via File > Options > Quick Access Toolbar (only in Excel 2010/2013):
General
A few small improvements and a few spelling corrections.
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.
Much faster
has been renamed to:
Convert unrecognized numbers (text?) to numbers
has been renamed to
Favorites & Shortcuts » Edit your favorite tools and shortcut keys...
has been renamed to
Web » Clean data and formatting...
and this utility has also been placed in the Format, Text and Numbers & Dates submenus
Much much faster when it involves entire rows or columns
Much much faster when it involves entire rows or columns
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')
Instead of just making the first character uppercase, this utility now detects the first word by skipping other characters such as numbers and punctuation mark.
For example a cell with the value "12 documents" will now be changed to "12 Documents" or "[document]" to "[Document]"
Improved. It now uses the value of a cell as displayed (using the cell's number format)
Improved (calculation) speed for these functions.
When choosing to export as Excel workbooks you can now also choose to export just the values.
Improved performance and progress info.
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%
Several improvements and a few spelling corrections.
A few small improvements and spelling corrections.
Massive speed improvement due to a new developed algorithm.
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. .
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.
This tool can be used to correct the reference in your workbook to the ASAP Utilities worksheet functions.
This can be useful if your workbook is used on another computer where ASAP Utilities is installed in a
different folder. For example the default installation folder of ASAP Utilities differs between a 32-bit and 64-bit Windows version.
This tool inserts an apostrophe (') in front of each formula in the selected cells, which turns them to text.
Note:
To turn the changed formulas to actual formulas again, you can use the following tool from ASAP Utilities "Numbers » Change not recognized numbers (text?) to numbers"
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
This tool removes all range names that have an invalid reference (#REF!).
A report with the results will be presented to you.
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 and & to normal characters.
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:
Your workbook's color palette/color-scheme is now copied too in case of an Excel export.
Your workbook's color palette/color-scheme is now copied too in case of an Excel export.
The cell's displayed value is now used. For example if you have a date, 12/14/2012 displayed as Dec 14, the value "Dec 14" will be used instead of the numerical date.
A cell's displayed value is now used. For example if you have a date, 12/14/2012 displayed as Dec 14, the value "Dec 14" will be used instead of the numerical date.
You can now choose to create a backup copy in either your backup folder, or in the same folder as your workbook.
via ASAP Utilities Options » New tools in development (English only)
Transform a table into a 3 column table that you can easily use as a source for for example a pivot table.
When creating text-files, this tool now uses your current workbook settings for the decimal- and thousand separator in the output. Unless you choose specific settings on the form. Previously Excel's default VBA (US international) settings were used.
When creating text-files, this tool now uses your current workbook settings for the decimal- and thousand separator in the output. Unless you choose specific settings on the form. Previously Excel's default VBA (US international) settings were used.
Added automatic detection and removal of leading or trailing spaces.
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)
=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.
Added support to use the {tab} or {lf} codes to insert either a tab or line feed (alt+enter) character.
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.
The links in =HYPERLINK() formulas are now used too.
Links entered as text or a reference to a cell is supported such as for example
=HYPERLINK("//www.asap-utilities.com", "ASAP site") or =HYPERLINK(A1, "ASAP site")
The links in =HYPERLINK() formulas are now used too.
Links entered as text or a reference to a cell is supported such as for example
=HYPERLINK("//www.asap-utilities.com", "ASAP site") or =HYPERLINK(A1, "ASAP site")
Improved speed
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.
A few small improvements.
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.
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.'
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
. Change julian dates to normal dates in selected cells
This tool has been updated so that besides the yyddd and yyyyddd now the JD Edwards (AS/400) cyyddd format is also supported. Their system adds a 0 or 1 in front of the year representing the century (0 = 1900, 1 = 2000, Jan 15, 1910 is 010015, Jan 15, 2010 is 110015).
Skipped the confirmation at the end "The data has been copied to the clipboard". This was removed by request from users who used this utility a lot.
New, when you merge the data you can now choose to have the filename listed in column A.
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:
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:
A few small improvements
By request, the utility now also copies the row height.
Now automatically adds http:// in front of the hyperlinks if needed.
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.
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.
Contains a new option: Help improve ASAP Utilities, Allow ASAP Utilities to report anonymous usage statistics. By default this option is turned on.
These usage statistics don't include personal information, such as your name, company name or email address. Usage statistics do include the following information from your computer: Windows version and language, Excel version and language, ASAP Utilities version and language, and the id's of the 10 tools used most often.
This information helps with the further development of ASAP Utilities and its documentation and translations.
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"
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".
Improved speed, especially when it comes to deleting rows or columns.
This utility doesn't work on shared workbooks. Instead of giving an error this tool will now tells you that upfront.
If you unshare the workbook then you can use this utility.
This utility doesn't work on shared workbooks. Instead of giving an error this tool will now tells you that upfront.
If you unshare the workbook then you can use this utility.
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.
You can now specify the number of empty rows to insert in between.
via: ASAP Utilities Options » New tools in development (English only)
When you use a function from ASAP Utilities in your workbook and the workbook is opened by someone who has install ASAP Utilities in a different folder, then these formulas might give an error (#NAME?) because ASAP Utilities can't be found. If you get such a workbook and you run this utility, it will be corrected.
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.
The utility now also automatically recognizes time values at the end of the value. It does this automatically if the time is written in any of the following formats hh:mm:ss, h:mm:ss, hh:mm:ss AM/PM or h:mm:ss AM/PM. The utility also recognizes hh:mm:ss.000 and h:mm:ss.000 but in that case the milliseconds are stripped off.
Improved installer.
A few minor improvements.
You can quickly add the tool from within the result window to your Favorites-menu by pressing the + button:
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:
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:
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.
Now has buttons to quickly check, uncheck or inverse all options.
This utility is handy to quickly clean up data in general.
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.
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:
We removed the startup-questions (such as "Do you want to convert all text in the selected cells to UPPERCASE?") from several tools.
These tools either don't change your data or settings, or can be easily undone or canceled nowadays.
This applies to the following tools:
. Apply standard format to selected cells
. Center across selection (without merging)
. Change not recognized numbers (text?) to numbers
. Change to lowercase
. Change to UPPERcase
. Convert percentages to numbers (e.g. 5% to 5)
. Copy values to empty cells below filled cells in selection
. Count and/or color duplicates in selection...
. Decode all URL and HTML encoded text
. Delete all borders inside selection
. Delete leading and trailing spaces
. Delete leading, trailing and excessive spaces
. Fill 'between values' linear in selection (horizontal)
. Fill 'between values' linear in selection (vertical)
. Flip selected cells
. 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)
. Place a border around each page
. Print preview selection
. Random numbering of cells (without duplicates)
. Remove all conditional formatting in selection
. Reverse text in selected cells
. Select cell in selection where value changes
. Start Each Word With Uppercase
. Start first word with Uppercase
. Unmerge cells in selection
For your information, you could already turn off all the startup questions via: ASAP Utilities Options » Settings, language and contact information...
and then the checkbox "Ask for confirmation before starting certain utilities (recommended)" on the "General" tab.
ASAP Utilities does not (yet) support the 64-bit edition of Excel 2010.
Besides a warning about this during the installation, the program will now also tell you this when you start ASAP Utilities in Excel 2010 64-bit (instead of giving an error message).
Just to be clear, ASAP Utilities does work with both 32-bit and 64-bit Windows.
At this moment we don't have a short-term planning for a 64-bit version of ASAP Utilities. This is due to the fact that we would most likely have to completely rewrite the program in order to keep it secure (from Visual Basic to MS Visual Studio), which costs a lot of time and money and such a solution wouldn't work with Excel 2000, 2002/XP and 2003 anymore. This requires us to maintain and publish two versions of ASAP Utilities.
Furthermore, there seem to be only very few people that require the 64-bit edition of Excel 2010 instead of the 32-bit edition of Excel 2010. Most people might think that the 64-bit version is faster, but it isn't. The main advantage is that you can use Excel workbooks that are over 2GB (2 gigabyte!) in the 64-bit edition.
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:
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.
This utility can now also be used to copy charts or other objects to the clipboard.
Therefore the utility has been renamed to:
Export » Put the selection as bitmap-image on the clipboard (as on screen)
This utility can now also be used to copy charts or other objects to the clipboard.
Therefore the utility has been renamed to:
Export » Put the selection as image on the clipboard (as on screen)
This utility can now also be used to copy charts or other objects to the clipboard.
Therefore the utility has been renamed to:
Export » Put the selection as image on the clipboard (as on printer)
A few small (speed) improvements.
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.
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.
The setup is now translated into Dutch, German, Spanish and French too.
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.
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.
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.
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.
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.
Improved speed. Furthermore, if you have hidden rows at the end of your data, they now remain hidden.
Improved speed. Furthermore, if you have hidden rows at the end of your data, they now remain hidden.
The amount of files listed is now a worksheet formula. This has the benefit that when you use the autofilter to narrow down the list it amount of files listed is updated and it shows only the number of files displayed by the filter.
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)
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.
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..
Improved speed for some files when they are exported in a separated text format.
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.
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'.
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'.
NEW: Sort each row in selection individually ascending (left to right)
NEW: Sort each column in selection individually ascending (top to bottom)
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.
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.
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.
All the tools are now also available in the French language (Français).
If you have the French language of Excel then ASAP Utilities will now start in French.
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.
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 addedAll 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.
Spanish Excel 2007 with ASAP Utilities in its menu
- 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.
German language added
- 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.
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years