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 ...

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 ...

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 ...

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 ...