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

Posted on January 18th, 2010 by Bastien
Filed under: ASAP Utilities, how to | 3 Comments »

How to: Create a pipe delimited 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 [...]

Posted on January 15th, 2010 by Bastien
Filed under: ASAP Utilities, how to | 3 Comments »

How to: Check the spelling on multiple or all 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.

Posted on January 13th, 2010 by Bastien
Filed under: General, how to | No Comments »