ASAP Utilities - ASAP Utilities Blog

The following video will show you how to how to fix trailing minus signs in Excel by using ASAP Utilities. This can be useful if you have imported data from a system that reports negative numbers with a trailing minus. If you've ever worked with imported numbers you might have faced the problem that negative numbers have ...

ASAP Utilities how to with ASAP Utilities

Video: How to delete all empty rows in Excel with ASAP Utilities

Nov 5, 2007 Bastien 0 Comment

Example file with empty rows that need to be removed

The following video will show you how to remove all empty rows in Excel by using ASAP Utilities. This can be useful if you have a large amount of data imported or copied together that you now want to clean up. An approach to remove all empty rows can be to sort the worksheet. However if you ...

ASAP Utilities General

Protect sheets: The EnableSelection property is not saved + Excel update fix

Oct 23, 2007 Bastien 0 Comment

Yesterday I got the following question: "When using the 'protect multiple sheets at once and checking only the 'select unlocked cells checkbox I find that once I save and reopen the sheets now behave as if both the 'select unlocked cells as well as the 'select locked cells seems to be in effect as I ...

ASAP Utilities how to with ASAP Utilities

Video: How to delete the first 3 characters in a column in Excel with ASAP Utilities

Oct 22, 2007 Bastien 0 Comment

How to delete the first 3 characters in a column - before

The following video will show you how to strip the first 3 characters from a column in Excel by using ASAP Utilities. The example in the video shows a list of article numbers. Now in this case we want to remove the first 3 characters. This can be done with an Excel formula such as =RIGHT(A2,LEN(A2)-3) in a ...

ASAP Utilities how to with ASAP Utilities

Video: How to fill empty cells with the value above in Excel with ASAP Utilities

Oct 22, 2007 Bastien 0 Comment

Copy values to empty cells below filled cells in selection - before

The following video will show you how to fill empty cells with the value above in Excel by using ASAP Utilities. The example in the video shows a table with several car-brands. Now in this case we want the brand-names copied down so that the empty cells are filled with the brand names. After this we can ...

ASAP Utilities how to with ASAP Utilities

Video: How to sort the sheet-tabs in Excel with ASAP Utilities

Oct 18, 2007 Bastien 1 Comment

The following video will show you how to sort the sheet-tabs in alphabetical order in Excel by using ASAP Utilities. The example in the video show a workbook with several sheets with city-names: In the Excel menu choose ASAP Utilities » Sheets » Sort all sheets in alphabetical order Then result will then look like: Note: This old video is no ...

ASAP Utilities

Fixed the statup delay in Windows XP + Excel 2007 when opening a file through the Windows Explorer

Oct 12, 2007 Bastien 2 Comment

The latest version of ASAP Utilities (pre-released today) will solve an issue that can appear when you have both Windows XP and Excel 2007 installed. "After installing the latest version of ASAP-Utilities after upgrading to Office 2007, I began to encounter a problem with Excel 2007 where, upon clicking on an Excel file to open, the ...

ASAP Utilities

Pre-release ASAP Utilities version 4.2.1 RC3

Oct 12, 2007 Bastien 3 Comment

Example of the function =asaprandompassword()

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. In this update have made a few small improvements and added a new worksheet function that make creating strong passwords easy: =ASAPRandomPassword(length, use_symbols)This new function will return a strong password which contains of - both uppercase ...

ASAP Utilities how to with ASAP Utilities

Video: How delete leading, trailing and excessive spaces in Excel with ASAP Utilities

Oct 11, 2007 Bastien 0 Comment

Example of leading, trailing and excessive spaces

The following video will demonstrate you how to delete leading, trailing and excessive spaces from cells (trim) in Excel by using ASAP Utilities. The example in the video shows an address list with too many spaces: Several street- and city names contain a space at the beginning and/or at the end. Furthermore in a few names there are ...

ASAP Utilities how to with ASAP Utilities

Video: How to extract hyperlinks in Excel with ASAP Utilities

Oct 10, 2007 Bastien 1 Comment

The following video will demonstrate you extract hyperlinks from cells in Excel by using ASAP Utilities. The example in the video show a list of websites that I copied from my links-page. There is no easy way in Excel itself to get the hyperlinks from the cells. That's why I built such a functionality into ASAP Utilities. First ...

ASAP Utilities how to with ASAP Utilities

Video: How to sort by color in Excel with ASAP Utilities

Oct 9, 2007 Bastien 2 Comment

The following video will demonstrate you how to sort by color in Excel by using ASAP Utilities. It is not possible to sort by color in Excel. However we find that many people use colors to "tag" certain cells that need to be processed later. The example in the video show a list of keywords such as my ...

ASAP Utilities General

Macro: Export each column to a separate sheet

Oct 9, 2007 Bastien 0 Comment

Last week I got a question from Danielle: "I have a spreadsheet with 75 columns each containing between 48 to 50 rows. I would like to be able to export each column to either a separate sheet or a separate file. Sort of like the export worksheets as separate files function. Does this ...

ASAP Utilities how to with ASAP Utilities

Video: How to remove leading zeros in Excel with ASAP Utilities

Oct 8, 2007 Bastien 0 Comment

The following video will demonstrate you how to remove (or trim) leading zeros from numbers within a range in Excel by using ASAP Utilities. This utility also works for numbers that are not recognized by Excel or are proceeded with an apostrophe (such as '2). You can usually recognize these numbers because they are left-aligned: The following video ...

ASAP Utilities

Pre-release ASAP Utilities version 4.2.1 RC2

Oct 5, 2007 Bastien 4 Comment

(Re) build the ASAP Utilities favorites menu toolbar

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. I have also experienced some crazy things with customizing the ribbon (qat) and empty Excel dialogboxes due to dynamic labels (getLabel). I will write more about that in a separate post. New/improved Fill » Random numbering of ...

ASAP Utilities how to with ASAP Utilities

Video: How to select/find unique values in a selection in Excel with ASAP Utilities

Oct 3, 2007 Bastien 0 Comment

The following video will demonstrate you how to select the unique values within a range in Excel by using ASAP Utilities. The video demonstrates how to select the color names that appear only once in the list: Note: This old video is no longer available and will in 2021 be replaced with a new version in a modern ...

ASAP Utilities how to with ASAP Utilities

Video: How to to list filenames in a folder in Excel with ASAP Utilities

Oct 2, 2007 Bastien 0 Comment

The following video will demonstrate you how to list filenames in a folder in Excel by using ASAP Utilities. It is a perfect tool for creating catalogs of the files of your CD's and DVD's. The video will demonstrate how to import the contents of a folder and shows you how you can easily select a certain folder ...

ASAP Utilities

New version released: ASAP Utilities 4.2

Sep 25, 2007 Bastien 0 Comment

Today I have released the new version of ASAP Utilities. This new version is improved in severals ways. I would like to thank everybody for their feedback the past months! » What's new » Versions History » Download I have changed the version number from 4.1 to 4.2 because the ASAP Utilities menu is now nicely integrated into the Excel ...

ASAP Utilities

Pre-release update: Default filename in 'Export selection or active sheet as new file…'

Sep 13, 2007 Bastien 0 Comment

Export selection or active sheet as new file: default filename

I have just put a new pre-release online which updates the utility Export » Export selection or active sheet as new file.... The default proposed filename now contains the name of your workbook and the selected sheet. If you have chosen to export a range of cells instead of the entire sheet, the proposed filename also ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC4

Sep 13, 2007 Bastien 0 Comment

Yesterday I have published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. Two new utilities Sheets » Freeze panes on multiple sheets at once Freeze panes on all or all selected sheets at once bases on your current selection. Normally in Excel you can only do this one one sheet ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC3 (Excel 2007 ribbon)

Aug 30, 2007 Bastien 2 Comment

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. The major change in this version is in combination with Excel 2007 where ASAP Utilities now has its own tab in the ribbon. Preview with the blue (Excel default) theme: Preview with the black theme: A screenshot of ...

ASAP Utilities

Preview ASAP Utilities ribbon for Excel 2007

Aug 28, 2007 Bastien 2 Comment

I am currently working on an Excel 2007 ribbon-menu for the new ASAP Utilities. Right now the ASAP Utilities menu is visible in the Add-ins tab but the new version will have its menu integrated in the ribbon. Preview of the new ASAP Utilities menu A preview of the new ASAP Utilities ribbon in Excel 2007: More information ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC2

Aug 10, 2007 Bastien 0 Comment

Screenshot - Insert current date and time with seconds

I have made a few improvements to ASAP Utilities based on the advice of several people. Added: Fill » Insert current date and time with seconds Insert the current date and time into the active cell. Unlike Excel's built in shortcut "Control+:" this utility also inserts the seconds. (timestamp) By default this utility can be started with the shortcut ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC1

Jul 19, 2007 Bastien 0 Comment

Added the options to select cells with a certain number format

Just when you think everything is right a new bug pops up... This afternoon I have released a pre-release of the new version that solves a bug in the Paper Saver utility. There was an error in the progress-display that caused an error when starting the utility and therefor made it impossible to use. This is ...

ASAP Utilities

New version released: ASAP Utilities 4.1.2

Jul 16, 2007 Bastien 0 Comment

Today I have released the new version of ASAP Utilities. This new version is improved in severals ways. I would like to thank everybody for their feedback the past months! » What's new » Versions History » Download Up next: A special ASAP Utilities menu in the Excel 2007 ribbon. (However, only a very small percentage of the Excel people ...

ASAP Utilities

New version in progress – pre-release 4

Jul 10, 2007 Bastien 2 Comment

I have been working on the new version of ASAP Utilities today and I've just released another preview version, ready for download and testing. New ASAP Utilities Options » Start the last used utility again... This will re-start the last run utility used in ASAP Utilities. For example if the last utility you used was 'Export selection as HTML ...