Using english and non-English Excel commands simultaneously in a non-English installation
in [Functions]
|
From: Bob Phillips on 11 Mar 2010 14:34 Michael, There are also a couple of webpages that I use, http://dolf.trieschnigg.nl/excel/excel.html and http://cherbe.free.fr/traduc_fonctions_xl97.html -- HTH Bob "Michael.Tarnowski" <emte69(a)gmx.de> wrote in message news:d8cf3f2c-ec10-4dae-b53d-936164768d1f(a)q16g2000yqq.googlegroups.com... On Mar 11, 4:00 pm, "HK" <a...(a)b.com> wrote: > If you have Office 2007 you can buy Office Language Pack here for $25. > > http://buy.trymicrosoftoffice.com/buyus/product.aspx?r=US_USD&family=... > > I bought originally a Danish Excel and later on the English language pack > and it works absolutely fine. > > Hans > > "Michael.Tarnowski" <emt...(a)gmx.de> skrev i > meddelelsennews:80870abc-d2f0-4b5e-94dc-a4b708df6350(a)v20g2000yqv.googlegroups.com... > > > Hi community, > > I like this forum very much - I got many valuable insights from it. In > > the past I had an English Excel installation at the office available, > > recently my employer moved to the German version and deinstalled the > > english one. > > Now, when i use a english command like =VLOOKUP(A1,'Sheet 2'! > > A1:H200,8,FALSE) adopting the country settings for "," with ";" Excel > > comes up with #NAME? since I used the english term, not the german one > > - but sometimes the german equivalent is not at hand as fast as > > needed ;-) > > > However if a open a english coined workbook of a US/UK colleague with > > a built-in commands in English, the german Excel instllation is able > > to translate. > > So, is there a kind of Addin or multi-language extension available to > > use english and non-english built-in commands in a non-English > > installation simultaneously? > > > Thks for any help, have a great day > > Michael Thank all of you for help and advices. - But I'am looking for a kind of "built-in-able translator" ;-) Bob gave me the important glue "held in tokenized form, the language version does the translation. " - I did some googling with the keywordds "translation excel function name" and got the amazing result there is an add-on: TranslateIT (formerly:MultiLingual Formula Translator), http://members.chello.nl/jvolk/keepitcool/download.html --- Translate complete formulas between 12 excel languages (English, Dutch, German, French, Italian, Spanish, Portuguese, Danish, Swedish, Norwegian, Finnish and Russian). Can be very useful in multilanguage environments or when you read the english excel newsgroups, and happen to own a localized Excel version. Version 3. ADDED a routine to "localize" Analysis Toolpak functions from a "foreign" file to local language. parsing changed to use RegEx. --- Michael
From: HK on 12 Mar 2010 02:21
Michael > Thank all of you for help and advices. - But I'am looking for a kind > of "built-in-able translator" ;-) > Bob gave me the important glue "held in tokenized form, the language > version does the > translation. " - I did some googling with the keywordds "translation > excel function name" and got the amazing result there is an add-on: > TranslateIT (formerly:MultiLingual Formula Translator), > http://members.chello.nl/jvolk/keepitcool/download.html > --- You might also want to consider the following: Copy into Excel (A1:B340) the English and German function names for example from one of the webpages mentioned in an earlier answer. Select A1:B340 and import as Custom lists (Import lists from rows). Now in an empty cell write for example TRANSPOSE (without equal sign), press the small square in the lower right of the cell and drag downwards (or to the right) and you will see the German equivalent MTRANS. It works both ways. I you want to delete all these more than 300 hundred custom lists again I think you will need a macro. Hans |