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.
Posted on April 28th, 2008 by Bastien
Filed under: ASAP Utilities | No Comments »
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 [...]
Posted on January 31st, 2008 by Bastien
Filed under: ASAP Utilities | 4 Comments »
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 [...]
Posted on January 22nd, 2008 by Bastien
Filed under: ASAP Utilities | 3 Comments »
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 [...]
Posted on January 9th, 2008 by Bastien
Filed under: ASAP Utilities | 2 Comments »
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!
Posted on November 28th, 2007 by Bastien
Filed under: ASAP Utilities | 10 Comments »
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: [...]
Posted on November 20th, 2007 by Bastien
Filed under: ASAP Utilities | 12 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, 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, Video | No Comments »
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 [...]
Posted on October 23rd, 2007 by Bastien
Filed under: ASAP Utilities, General, Excel 2007 info | No Comments »
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 [...]
Posted on October 22nd, 2007 by Bastien
Filed under: ASAP Utilities, Video | No Comments »
