Language, other than US English

Location: http://www.mvps.org/dmcritchie/excel/language.htm      
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
[View without Frames]

This is a tip (Tom Ogilvy) on translating English functions to the language of your Excel.

  1. Go into the VBE in the immediate window
  2. Put in something like
    Range("A1").Formula = "=Sum(B1:B10)"
  3. Then hit enter.  Now look at A1 and the formula should be translated.
There is at least one MS KB article on obtaining a list of function names used in another language but I can't find them at the moment. -- David

 


The following macros were posted by Harald Staff (misc 2000-10-02 & 2000-10-27)

Just a tip: I use this little macro to insert english/american formulas into my norwegian Excel.   It translates syntax to Norwegian and corrects the [list] separators.  To enter an english formula (like copy-paste from these newsgroups), use this little macro and Excel translates to your language.

Sub InsertEnglishFormula()
  ActiveCell.Formula = _
    InputBox("Insert and translate this formula:")
End Sub
To see the USA english formula of the active cell, use this little macro:
Sub EnglishFormula()
    MsgBox ActiveCell.Formula
End Sub
Related information on viewing formulas can be found on my Formula page (David).

The Following has not been testing under another language with is it's intended use.

I don't know how US comma delimitors would affect this so you
might want to run a few tests -- I guess you would have to
change them to your own after pasting and before hitting [OK].

Cells to the right of Column A should be blank to allow expansion
across them if needed.

Sub ShowEquivalentFormula()
   Dim USFormula As String
   USFormula = InputBox("Supply US version of formula," _
      & Chr(10) & "Cell A1 will receive changed formula", _
      "Translate formula", "=LEN(A2)")
   If USFormula = "" Then
      MsgBox "you chose CANCEL"
      Exit Sub
   End If
   On Error GoTo incomplete
   [a1].Formula = USFormula
   [a1].Formula = "'" & [a1].Formula
   Exit Sub
incomplete:
   MsgBox "Error occurred while attempting to convert" _
     & Chr(10) & USFormula & Chr(10) & Chr(10) & _
     "Please ignore results in cell A1"

There was a page for code (code/substitute.txt for this page but found did not need to convert the URLs for direct usage in Babel Fish afer all.
Function URL_x(str) As String
    'David McRitchie, 2003-07-14 for language.htm
     'usage   =personal.xls!url_x("http://abc.com")
     '-- turned out did not need on language.htm page
     URL_x = Application.Substitute(Application.Substitute( _
       Application.Substitute(Application.Substitute(str, _
        ":", "%3A"), "/", "%2F"), "=", "%3D"), "?", "%3F")
End Function

Foreign language URL's translation by available in any of the following manner:
 

  • by pasting into the URL section of http://babelfish.altavista.com/  or http://www.systransoft.com/  to translate the URL and links navigated to thereafter.  Note Babel Fish and SysTran are the same. 
    Available languages to or from English are: Spanish, French, German, Italian, and Portuguese.
     
  • In IE you can right-click on a hyperlink and copy shortcut for pasting. 
     
  • In IE you can right-click on a hyperlink and choose from the context menu "Translate".  You must first obtain the Google toolbaras (see ie6.htm).
     
  • or by a direct link through Babel Fish, for example Laurent Longre's site:
    http://longre.free.fr/   automatically from French to English using Babel Fish
    http://babelfish.altavista.com/babelfish/urltrurl?lp=fr_en&url=http://longre.free.fr/index.html
     
    Once you do the translate it is hard to believe you are looking at a machine generated translation of Laurent Longre's page from French to English, linked to pages will also be translated, watch out for coding.  Note:  Laurent has some pages in English -- Excel add-ins [-- http://longre.free.fr/english/ --]

    A smaller version of this is currently included at the end of my [index] page.

    The Babel Fish translator has been used for some Fun and Games to artificial languages see Google Humor on my Fun Page.


    Foreign language Function Dictionaries:
    http://cherbe.free.fr/fonctions_XL.ZIP (site: Christian Herbé This Excel table also available in HTML format at http://cherbe.free.fr/traduc_fonctions_xl97.html « and is marked courtesy of Laurent Longre


    Language Translations for Excel particularly for Dutch, posting by Eric van Uden, 2003-05-19, http://groups.google.com/groups?threadm=%23psBVcmHDHA.3084@tk2msftngp13.phx.gbl   get XLmenufundict «, Jan Karel Pieterse, zip file, available at http://www.oaltd.co.uk/mvp/ has a translation list of the Excel built-in command bars and controls and the Excel worksheet functions for the international user:  English, Dutch, Deutsch, Japanese (!), French, Swedish


    MS Excel: Analysis ToolPak Translator 7.0 -- http://www.acoustics-noise.com/ATPtranslator.shtml -- Eric Desart with Jurgen aka KeepItCool, Ron de Bruin, Laurent Longre, Jan Karel Pieterse, Roland Greve

    I think it is based on Ron's material on John Walkenbach's site
    -- Help Context IDs -- http://j-walk.com/ss/excel/tips/tip89.htm updated (English only) for Excel 2000-2003 http://www.rondebruin.nl/id.htm on his own site.

    Also see Norman Harker's function list, download at http://www.contextures.com/functions.html -- includes a Dutch translation (done by Ron de bruin) also some related notes on Ron de Bruin's site http://www.rondebruin.nl/id.htm


    TranslateIT (formerly:MultiLingual Formula Translator), Jurgen aka KeepItCool, it's link is: http://members.chello.nl/keepitcool/download.html
    Toolbar with lookups for functions (bilingual) userform for translation and localization of complete formulas to and from 12 languages with cut and paste for NG browsing/posting. autotranslation of ATP functions (similar but faster than ATP [Analysis ToolPak] translator) Full list of functions in 12 languages.
    Excel Function Dictionary « by Peter Noneley is a reference to definitely download and maintain on your computer, the workbook has 157+ sheets each with an explanation and example of an Excel function.
    This is not language related but is a great reference and compatible with either of the above language translation workbooks above. I think Peter and others are working on language translations.

    Related


    This page was introduced on July 27, 2000. 

     

    [My Excel Pages -- home]    [INDEX to my site and the off-site pages I reference] 
    [Site Search -- Excel]     [Go Back]    [Return to TOP

    Please send your comments concerning this web page to: David McRitchie send email comments


    Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved