I got a question from Ryan: I have a bunch of excel cells and I need them all to have no spaces and no dashes so the first one would be: 185444001 and so on. How can I use ASAP Utilities to remove all spaces and dashes? You can do this very quick with the [...]

Posted on February 10th, 2009 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | Comments Off

I'm sure you know you can enter a new line/line break by pressing Alt+Enter. But working with these newline characters can sometimes be a bit difficult, for example if you want to remove or replace them. If you have cells with multiple empty lines it can be difficult to quickly replace them all. Method 1: [...]

Posted on February 10th, 2009 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 1 Comment »

If you have a lot of data it can be difficult to identify and remove the empty rows. There is no way in standard Excel to quickly remove all empty rows* so it can be a time-consuming job. You need to use a macro for that. Empty rows in your table can cause problems with [...]

Posted on February 4th, 2009 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | Comments Off

Enno asked me the following: "... When I value-copy ranges where the If-function was used with a return value of "" (empty string), the cells are not blank, hence ISBLANK() = FALSE. Could you add a feature to remove empty strings? ..." Well, you can do this already with ASAP Utilities, although you cannot find [...]

Posted on November 13th, 2008 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | Comments Off

A short macro that will unhide all columns and rows in order to make all data visible again. Might be useful in some cases. Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = False End Sub If you want more control on which rows and/or columns to [...]

Posted on October 21st, 2008 by Bastien
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities | Comments Off

Just got a question that I found interesting to mention here: I am looking for following feature in ASAP Utilities: Count number of user specified characters in a cell. e.g. I have a cell that has values "a,b,c,d,e". I would like to have a utility that tells me either a. there are 4 "," characters [...]

Posted on July 2nd, 2008 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 5 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