How to: Quickly remove duplicated records

Remove duplicated records

At this moment ASAP Utilities already contains several tools to manage duplicates. However a special tool for duplicate records was still missing... until now! You could already identify or remove duplicated records with a workaround by merging the cell contents into a temporary added column and then use ASAP Utilities' "Conditional row and column select, hide or ...

How to: Split data table into multiple worksheets (and save time)

Export data in parts to multiple sheets

Many people have asked me the past years if ASAP Utilities has an option to split a table into several sheets. Either per so many rows, or by value. Until recently that wasn't possible, but now it is!. In cooperation with several users we have created a new utility. In the new version of ASAP Utilities ...

How to: Remove or replace line breaks and carrage returns in cells

There are few quick methods to remove the line breaks and carriage returns in cells. By default you might not know an easy and quick way to do this but it is fairly simple, either with just Excel, or with the help of ASAP Utilities. Let's say we have the following example. In this case the author has ...

How to: Create a pipe delimited file

Create a pipe-delimited text file

Last month I received the following question: I need to know how to convert an excel file into a pipe delimited file using the ASAP software. You can use the following tool to do this: ASAP Utilities » Export » Export selection or active sheet as new file... Then choose "CSV (comma separated value) or customer separated" and specify ...

How to: Check the spelling on multiple or all sheets

The spelling check is complete for the selected sheets

Last week I received the following question: How we can spell check on all sheets. Can you add this in next version/update? Well, you can already do this in Excel. Just select all or multiple sheets and then when you start the Spelling (F7) the spelling check will take place on the selected sheets.

How to: Insert a blank row after every 3rd row

initial-dataset

I just received the following question which might be interesting the share with you. ASAP Utilities contains many tools and one of the strengths is that you can often use a combination of the tools to accomplish what you need. The question I received this week: I want to insert a blank row after every 3rd row ...

Excel 2010: Use the 32 or 64 bit edition? 32 Bit might be wiser…

MS Office 2010 logo

The new version of Office, Office 2010 (Office twenty-ten) will be available in both a 32 bit and a 64 bit version. All previous version of Office were 32 bit. Office 2010 will be released in the first half of 2010. At this moment our advise is to install the 32 bit version of Office, even ...

Parlez-vous français? – Pre-release version 4.5.6

paris-eiffeltower-2009

Parlez-vous français? / Do you speak French? ...then I have good news for you! ASAP Utilities is now also available in the French language. If you have the French language version of Excel then ASAP Utilities will start the first time automatically in French (Français). You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities ...

Remove all empty rows – within your selection

remove all empty rows

Last week I received the following question: Bastien, First, thank you so much for the best Excel add-on ever! Is there a way to remove empty rows in a only a selected section of the worksheet, not the whole worksheet? Or have I missed this option that is already included? Surely you can do this! The utility "Columns & Rows » ...

Russian review of ASAP Utilities and other Excel add-ins

3D News - Daily Digital Digest

Today the Russion website, 3D News, has written an article about Excel plugins (add-ins) and how these can speed up your work. We're proud to see that ASAP Utilities is also mentioned in the article. We are working for many years (over 10 years now) on ASAP Utilities to help you to speed up your work ...