ASAP Utilities - ASAP Utilities Blog - Page 6

ASAP Utilities how to with ASAP Utilities

How to: Quickly find the utility you need

Feb 10, 2009 Bastien 0 Comment

Run and find a utility

With the new version 4.3 of ASAP Utilities it will be easier to find the utility you need with the tool "Find and run a utility...". We have improved this already existing utility. The results are presented better and you can now immediately start/run the utility from the search results. If you click on the ...

ASAP Utilities how to with ASAP Utilities

How to: Remove all spaces, dashes and other garbage from numbers

Feb 10, 2009 Bastien 0 Comment

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 following utility: ASAP ...

ASAP Utilities how to with ASAP Utilities

How to: Delete blank lines in a cell with multiple lines of text?

Feb 10, 2009 Bastien 1 Comment

Example of cells with linebreaks

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: Do it ...

ASAP Utilities how to with ASAP Utilities

How to: Remove all blank rows at once

Feb 4, 2009 Bastien 0 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 sorting ...

Pre-release version 4.3 available

Jan 27, 2009 Bastien 3 Comment

Pre-release version 4.3 available

We have been working on version 4.3 for the past year. That version has many improvements. A pre-release of the new version has been tested and reviewed by a selective group of people (thanks!) the past months. Most of the tools have been updated, improved and redesigned. A major improvement is also that you can now ...

Just released: ASAP Utilities 4.2.10

Jan 27, 2009 Bastien 0 Comment

ASAP Utilities version 4.2.10 (January 27, 2009) has just been released! This new version fixes a few bugs. While we're working on the next big updated version (4.3), a few people have reported some bugs that are now fixed in this new release. We recommend everybody to download and install the new version.

Soon to be released: version 4.2.9

Nov 18, 2008 Bastien 19 Comment

Text » Replace accented characters (Ã¡, Ã«, Ã± etc.)...

While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.8 that I've now fixed in version 4.2.9. More information and download of the pre-release: //www.asap-utilities.com/faq-questions-answers-detail.php?m=195 This version will probably be officially released next Thursday.

ASAP Utilities how to with ASAP Utilities

When Excel doesn't recognize empty cells correctly

Nov 13, 2008 Bastien 0 Comment

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 it in the description of ...

How to insert blank rows where the value changes

Oct 30, 2008 Bastien 3 Comment

Insert a blank row where the value changes

I got the following question from Jonathan this week: ... Don't know if this can be done at the moment, perhaps you could advise... I have a range of cells and I want to select ALL the cells/rows in the selection where the value changes. I can select the first cell where the value changes using 'Select Cells' ...

ASAP Utilities General How to how to with ASAP Utilities

Unhide all columns and rows

Oct 21, 2008 Bastien 0 Comment

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 unhide, you can also use this tool ...

Now available: ASAP Utilities 4.2.8

Sep 24, 2008 Bastien 12 Comment

Delete all objects in selected worksheets

Yesterday the new version of ASAP Utilities was officially released. You can read the details in the newsletter or you can immediately proceed to the download page. Besides several bugfixes, these are two new things: Objects & Comments » Delete all objects on current worksheetThis utility can now be used on multiple worksheets and has been renamed ...

ASAP Utilities General

Keep leading and remove only the trailing spaces

Sep 18, 2008 Bastien 0 Comment

Jeff recently asked: I really like your product but just came upon a capability it is missing: Delete trailing spaces (but keep all other spaces). I expect it would be simple enough to add; would you? I never expected anyone to need a tool to only remove the trailing spaces but he needs it on imported ...

ASAP Utilities General

Add trailing zeros

Sep 17, 2008 Bastien 1 Comment

Max asked the following: Can the "Fill fill up with leading zero's" option under be made to work on leading or trailing zeros? For instance, if I have three numbers: 1 12 123 I would run the option to fill them with trailing zeros so they would look like: 1000 1200 1230 We want to normalize the numbers so they would all be ...… Read more...

Soon to be released: version 4.2.8

Sep 16, 2008 Bastien 0 Comment

While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.6 and 4.2.7 that I've now fixed in version 4.2.8. More information and download of the pre-release: //www.asap-utilities.com/faq-questions-answers-detail.php?m=193 Version 4.2.7 was released on September 3rd. However a newsletter hasn't been sent out yet. I plan on doing this this ...

ASAP Utilities General

Replace formulas with their calculated results in multiple sheets

Sep 16, 2008 Bastien 2 Comment

It's time to update this blog more often. I will do this by writing about questions I answered by email and that might be interesting for others too. Tom asked: Formula » Convert formulas to their values: I was hoping you could tell me if there is there a way to do this for all the ...

Almost finished: ASAP Utilities version 4.2.6

Aug 5, 2008 Bastien 6 Comment

Busy

I'm almost finished with the updated version of ASAP Utilities: 4.2.6 Most changes in this version are corrections and bug fixes. More information and download: //www.asap-utilities.com/faq-questions-answers-detail.php?m=185 We're also working on version 4.3 which will contain several improvements and a very big step forward (that I can' t reveal yet). This is consuming a great portion of our time, but ...

ASAP Utilities how to with ASAP Utilities

Count the occurrences of a character in a cell

Jul 2, 2008 Bastien 5 Comment

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 b. simply tell me ...

New ASAP Utilities version 4.2.5 released!

May 30, 2008 Bastien 2 Comment

The new version of ASAP Utilities for Excel has just been released! This new version 4.2.5, May 29, 2008 is improved in a several ways. Read the full newsletter: //www.asap-utilities.com/asap-utilities-newsletter-2008-03.php

Pre-release ASAP Utilities version 4.2.5 RC3

Apr 28, 2008 Bastien 1 Comment

Updated: Export » Export worksheets as separate files...

I have just put a pre-release of the new version of ASAP Utilities online. This new version contains a few improved utilities and a few bug fixes.

Pre-release ASAP Utilities version 4.2.3 RC1

Jan 31, 2008 Bastien 4 Comment

Error

Last week version 4.2.2. was released. Unfortunately this version contains a few bugs. I have solved these and a new version will be released soon. The most annoying bug is in the utility "Range » Find / Replace in all sheets...". When you pressed the "Find all" button you immediately got Error 401: Application-defined or ...

New ASAP Utilities version 4.2.2 released!

Jan 22, 2008 Bastien 3 Comment

ASAP Utilities version 4.2.2 (January 22, 2008) has just been released! I would like to thank everybody for their feedback! Among other minor updates, these utilities have been improved: - Export » Export selected chart or range as image (file)... - Export » Export worksheets as separate files... - Import » Insert (delimited) text file... - Fill » List filenames in ...

Pre-release ASAP Utilities version 4.2.2 RC5

Jan 9, 2008 Bastien 2 Comment

I have just released the fifth pre-release of the new version of ASAP Utilities 4.2.2 which contains several new features and bug fixes. This new version is scheduled to be finished by the end of next week (January 18). Minor updates and bug fixes will be done. Bigger updates will be reserved for the release after ...

Office 2007 Service Pack 1 coming on December 11th

Dec 6, 2007 Bastien 1 Comment

Check for Microsoft Updates

For your information, next Tuesday the first Service Pack for Office 2007 will be released. Service Pack 1 for the 2007 Microsoft Office system will be available for download on December 11th. We will be sharing more details at that time, but the improvements are focused on stability, performance and security. I'm very curious if the ...

Pre-release ASAP Utilities version 4.2.2 RC1

Nov 28, 2007 Bastien 10 Comment

I have just released a pre-release of the new version of ASAP Utilities which contains several extended utilities (mainly import/export) and a few bug fixes. I would like to thank everybody for their feedback! New/improved 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 ...

Review: ASAP Utilities – You Sexy Thing

Nov 20, 2007 Bastien 12 Comment

ASAP Utilities Review

Did you know that ASAP Utilities is sexy? I didn't too but I found out it is yesterday when I read the following review on the UK website Dooyoo! by raehippychick. I would like to share her enthusiasm with you. Review by 'raehippychick' Advantages: Brilliant for any Excel user - simple, easy to use, saves time and tempers Disadvantages: ...