(C) 2009 - 2014 by Mourad Louha · All rights reserved

All posts tagged Excel Formula Translator

The Excel Formula Translator is now also available in a Greek version and extends the offer of the online tool and the website to 6 languages. The Online Tool recognizes all native Excel functions since version 2010 and translates these functions to all localized names offered by Microsoft.

Excel Formula Translator Greek

Many thanks to Petros Chatzipantazis and to Lydia Anyfantaki from the company ILYDA for supporting me in the translation to Greek. Petros is the managing director of ILYDA (UK) Ltd, the company behind the Ribbon Commander framework and a member of the practitioners board at the Council for Ubiquitous Intelligence (CUbInt), Emory Goizueta Business School. He publishes regularly free Excel tutorials and VBA Add-ins at Spreadsheet1.com. Lydia is an Excel enthusiast and a young entrepreneur, co-founder of the software development start-up company FLEXWARE Innovation Systems.

While implementing the Excel Formula Translator in PHP, I created an Excel workbook including all my translations of the Excel formulas, error codes and arguments of the CELL() and INFO() functions. I thought, it would be a good idea to offer the file for free at the end of this article. Please do not hesitate to send me an e-mail or leave a comment here, if you find an error in one of the translations.

To extract the formulas in the different languages, I had firstly inserted all available formulas in a column in the “Formulas” worksheet of the workbook. For this, I used the English version of Excel, as English is my reference language and I sorted all formulas in alphabetical order. Of course, as I am usually using the German version of Excel, I had to install the English language pack.

Excel Formula Translator

Read more

I recently released version 1.50 of my free online Excel Formula Translator. The translator can be used to translate both single Excel Formulas and combined complex formulas. For example the formula =PROPER(MID(A1;FIND(“.”;A1)+1;FIND(“@”;A1)-FIND(“.”;A1)-1)) to extract the first and last name from an e-Mail address is translated to =NOMPROPRE(STXT(A1;TROUVE(“.”;A1)+1;TROUVE(“@”;A1)-TROUVE(“.”;A1)-1)) in French.

MSDN actually provides 43 language packs for Microsoft Office 2010, which I downloaded and installed in a virtual machine. I then compared the Excel functions, the Excel error codes and the arguments of some specific functions to the English version. And I have found 32 languages which have differences and included these languages in the translator.

Excel Formula Translator

However, in some languages the differences are minimal. For example, the only difference I found in the Japanese language pack is the DOLLAR() function which was replaced by YEN(). Another example is Thai, where the only difference is the argument “System” for the INFO() function. So, for these languages, the translator will in most cases return the same result as for English.

Read more