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

## Soon to be released: version 4.2.8

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: http://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 ...

## Replace formulas with their calculated results in multiple sheets

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

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: http://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 ...

## Count the occurrences of a character in a cell

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

## Excel 2007 sheet copy: Application-defined or object-defined error

When you use the code sheet.copy normally a new workbook is created with a copy of that particular sheet. However in Excel 2007 (SP1) if the original workbook contains a macro when you run the code the first time you (might) get the following error: I could only reproduce this error when the original workbook where ...

## New ASAP Utilities version 4.2.5 released!

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: http://www.asap-utilities.com/asap-utilities-newsletter-2008-03.php

## Pre-release ASAP Utilities version 4.2.5 RC3

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

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!

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