Hip hip hurray! (pre-release of the new version available)

Hello everybody,

The pre-release of the new version of ASAP Utilities now available.
New exiting tools have been added and several improvements have been made.

  • Do you often work with Excel's Filters or AutoFilters?
  • Did you ever wanted to change your conditional formatting to static formatting (like "copy > paste values" for formulas)?
  • Would you like a way to automatically have a cell'value or formula added as a comment?
  • Do you need to change the JD Edwards (AS/400) Julian dates to dates that Excel can handle?

    ...the new version will do all this and more.

The following page shows more information and a download link: Pre-release version 4.7.3

If you have any questions or comments on this release then please let me know. You can do so by leaving a comment or by sending me an email.

Kind regards,
Bastien Mensink

9 comments

Steven G

These are great features, Bastien, but I would really love to see a x64 bit solution.

Bastien

Hello Steven,

Thank you for your feedback.
Can you tell me what the most important reasons are for you to use the Excel 2010 64-bit edition?

Thank you in advance,

Kind regards,
Bastien Mensink

Kanwaljit

Hi Bastien,

May the Family Live 1000 Years !

There is a feature "Insert before and/or after each cell in yours selection".
Is there something like "insert the contents of column B before and/or after each corresponding cell of column A".
I have to join the contents of two or more columns a lot of time when the data downloaded from web is copied and we use text to column feature, often there is a need to join two or more columns which otherwise could not be kept in a single column at the time of using "Text to column" utility.

Sincere Regards
CA Kanwaljit Singh Dhunna

Bastien

Hell Kanwaljit,

Thank you for your feedback.

You can use the following tool to do that:
ASAP Utilities » Columns & Rows » Merge column data (join cells)…
//www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=61&utilities=58&lang=en_us

Kind regards,
Bastien

Kanwaljit

Hi Bastien,

May the Family Live 1000 Years !

Thanks a lot ! I was quite sure that there must be some utility to cater to this, but somehow missed that.

Sincere Regards
CA Kanwaljit Singh Dhunna

Kanwaljit Singh Dhunna

Hi Bastien,

May the Family Live 1000 Years !

We use drag and fill to complete the lists in normal environment. But in case of a filtered sheet it is not possible. I wish there could be a utility which could fill in the serial number and / or other lists in a filtered list :)

Sincere Regards
CA Kanwaljit Singh Dhunna

Bastien

Hello Kanwaljit,

Thank you for your feedback.

You can use the following tool to help you with that:
Fill » Quick numbering of selected cells…
//www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=113&utilities=104&lang=en_us

In case of a filtered list, it only numbers the visible cells in your selection.
It doesn't detect the data already entered like Excel does when filling series, but you can use the many options of the tool to create a sequence.

If you need additional help then please let me know.

Kind regards,
Bastien Mensink

morenito

Hello –
This is the coolest tool. I cannot figure out how to get files to save as .dbf. I am running windows XP with 2007 microsoft office. Can anyone help?

-Morenito-

Bastien

Hello Morenito,

Thank you for your compliment.
MS has removed the DBF export from Excel with version 2007 and 2010.
More information:
//www.asap-utilities.com/faq-questions-answers-detail.php?m=135

I have heard are few good reactions from people who used the SaveDBF add-in to create DBF files from Excel 2007. It used to be free, but I'm not sure now anymore.
http://thexlwiz.blogspot.com/

Kind regards,
Bastien Mensink