These days, with all the economical issues, it is more then ever important to see where you can save money. You have probably already heard from others or experienced yourself that ASAP Utilities can save you a lot of time with your work in Excel. But how much time (and money) does it actually save […]

Posted on August 19th, 2009 by Bastien
Filed under: ASAP Utilities | 4 Comments »

Last week I received the following question: I get sent Excel files from various vendors. I have to convert these to SAS datasets that get moved to a UNIX system. The SAS datasets can only contain ASCII 32-127. So I need to remove these from the Excel file. You can use the "Text » Advanced […]

Posted on August 13th, 2009 by Bastien
Filed under: General, How to, how to with ASAP Utilities | 3 Comments »

Last week I received the following question: Is there an ASAP Utilities function that can remove all negative numbers from a spreadsheet? I haven't found it yet. Yes there is. You can use ASAP Utilities to help you to quickly delete negative numbers. You can use the following tool to select all cells with negative […]

Posted on August 3rd, 2009 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 17 Comments »