Filed under: ASAP Utilities, how to on January 18th, 2010 by Bastien | 3 Comments »
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 used the shortcut Alt+Enter to put the last name on a new line.
But now we need it together on a single line, with a space between the first- and last name instead of a line break.
Instead of:
Bastien
Mensink
we need
Bastien Mensink, etc. etc.
Read more...
Filed under: ASAP Utilities, how to on January 18th, 2010 by Bastien | 3 Comments »
Filed under: ASAP Utilities, how to on January 15th, 2010 by Bastien | 3 Comments »
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 the pipe-character (|) as delimiter:
Of course you can use with any character to create a specific separated kind of text file.
Filed under: ASAP Utilities, how to on January 15th, 2010 by Bastien | 3 Comments »
Filed under: General, how to on January 13th, 2010 by Bastien | No Comments »
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.
Filed under: General, how to on January 13th, 2010 by Bastien | No Comments »
Filed under: ASAP Utilities, how to on December 31st, 2009 by Bastien | No Comments »
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 in an excel file containing 1000 rows. Can you tell how..
Sure I can! Read more...
Filed under: ASAP Utilities, how to on December 31st, 2009 by Bastien | No Comments »
Filed under: ASAP Utilities on December 7th, 2009 by Bastien | 12 Comments »
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 if you have a 64 bit OS. In this post I give you a few reasons why we think it is in most cases the best solution. Until there is proof of great benefits, the 32 bit version seems to be the best for compatibility and you don't seem to anything significant.
First, according to Microsoft: "64-bit Excel, simply put, is for building really really (really) big workbooks."
There a few things to keep in mind before you choose to install the 64 bit version of Office 2010:
- Most add-ins don't support the 64 bit version of Excel 2010
- At this moment ASAP Utilities does not work with the 64 bit version of Excel 2010, it only works with the 32 bit versions of Excel. In order to support the 64 bit version of Excel 2010 we have to create a special 64 bit version for it. However, the current tool we use from MS doesn't support that (MS Office Developer edition). Furthermore, at this moment Office is still a beta version from which MS hasn't released all the details yet, which makes the development of a 64 bit version uncertain. Besides we do need to use another program for the development of ASAP Utilities, which will probably be Visual Studio 2010, but that isn't released yet either. They way I see it at this moment is that it might perhaps be wise to see how many people will actually use the 64 bit version of Excel and then we can see if we can justify the extra time and money we need to put into the development of a special 64 bit version and maintaining both a standard 32 bit and a 64 bit version.
- The only major advantage of the 64 bit version at this moment seems to be that it can handle Excel files larger than 2 GB (2 Gigabyte!).
- No guarantee for speed. Unlike you might expect, the 64 bit version isn't twice as fast as the 32 bit version. Quote from the MS Excel blog: "I’ve heard some people comment that 64-bit Excel means that it’ll just run faster than 32-bit Excel. Well, that’s not true as a general rule. We have some tests that run a bit faster on 64-bit Excel, and other tests that run a bit slower on 64-bit Excel."
Interesting source to read:
MS Announcing the 64 bit version of Excel:
http://blogs.msdn.com/excel/archive/2009/08/28/excel-2010-now-with-more-bits.aspx
Office 2010 Beta – 32-bit or 64-bit – The Choice is Clear
http://www.pcpro.co.uk/blogs/2009/11/23/office-2010-beta-–-32-bit-or-64-bit-–-the-choice-is-clear/
MS Office 2010 website:
http://www.office2010themovie.com/
MS Office 2010 forums
http://social.technet.microsoft.com/Forums/en-US/office2010general/threads
Filed under: ASAP Utilities on December 7th, 2009 by Bastien | 12 Comments »
Filed under: ASAP Utilities on November 30th, 2009 by Bastien | No Comments »
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 Options » Settings, language and contact information...
In ASAP Utilities you can now choose between the English, Dutch, German, Spanish and French language:
According to Wikipedia, French is globally spoken by about 77 million people as a first language (mother tongue) by 190 million as a second language, and by about another 200 million people as an acquired foreign language, with significant speakers in 57 countries. It is an official language in 28 countries.
By offering ASAP Utilities in more languages, more people can benefit from it in Excel.
Besides adding the new language, there also also a few improvements in this new version 4.5.6 that we're currently developing and of which you can download the pre-release.
Read more...
Filed under: ASAP Utilities on November 30th, 2009 by Bastien | No Comments »
Filed under: ASAP Utilities, how to on November 9th, 2009 by Bastien | 1 Comment »
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 » Remove all empty rows" does indeed remove all rows without any data on the -entire- sheet. But you can remove all empty rows -within your selection- with the following tool:
ASAP Utilities » Columns & Rows » Conditional row and column select, hide or delete...
First select the range where the empty rows should be removed, then start the utility and with the following options it will remove all rows within your selection that are completely empty:
Filed under: ASAP Utilities, how to on November 9th, 2009 by Bastien | 1 Comment »
Filed under: ASAP Utilities on November 6th, 2009 by Bastien | No Comments »
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 and make things easier in Excel. It is great to read and feels as a compliment when independent magazines recognize and emphasize this.
You can view the original article at:
http://www.3dnews.ru/software/excel_plugins_review/index4.htm
Or a Google Russian to English translation of the article:
http://translate.google.com/translate?hl=en&sl=ru&tl=en&u=http://www.3dnews.ru/software/excel_plugins_review/
Filed under: ASAP Utilities on November 6th, 2009 by Bastien | No Comments »
Filed under: ASAP Utilities on November 3rd, 2009 by Bastien | 6 Comments »
¿Habla usted español? (Do you speak Spanish?)
Then I have good news for you:
ASAP Utilities is now also available in the Spanish language.
If you have the Spanish language version of Excel then ASAP Utilities will start the first time automatically in Spanish (Español).
You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » ASAP Utilities options and settings...
In ASAP Utilities you can now choose between the English, Dutch, German and Spanish language:
Besides adding the new language, there also also several improvements in this new version 4.5.5 that I'm currently developing and of which you can download the pre-release.
Read more...
Filed under: ASAP Utilities on November 3rd, 2009 by Bastien | 6 Comments »
Filed under: ASAP Utilities on September 2nd, 2009 by Bastien | 11 Comments »
ASAP Utilities version 4.5.4 (September 1, 2009) has just been released!
We're proud to announce that the new version of ASAP Utilities is available in the German language too.
We have also added two new tools and made several improvements.
More information is in the newsletter.
Filed under: ASAP Utilities on September 2nd, 2009 by Bastien | 11 Comments »
