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 […]

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 […]

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.