The following video will show you how to how to move or resize the selected range in Excel by using ASAP Utilities. With this utility you can easily move or resize your selected range of cells. This utility will only change you selected range of cells only, not the data underneath it. By default you [...]
Posted on May 5th, 2009 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 8 Comments »
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 [...]
Posted on November 9th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 5 Comments »
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 [...]
Posted on November 5th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off
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) [...]
Posted on October 22nd, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off
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 [...]
Posted on October 22nd, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off
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:
Posted on October 18th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 1 Comment »
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 [...]
Posted on October 11th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off
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 [...]
Posted on October 10th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 1 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 [...]
Posted on October 9th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 2 Comments »
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 [...]
Posted on October 8th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off