Language, other than US English

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.

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

Sub EnglishFormula()
    MsgBox ActiveCell.Formula
End Sub

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 is available now from basically any language into any other language with Google translate. Was using Babel Fish when I wrote this page handled English, Spanish, French, German, Italian, and Portuguese. I had started out on Lycos from Carnegie Mellon but learned about AltaVista later on from my brother.

It is now 2019 and Babel Fish has not been around for five years, but I have been Google Translate for many years now, and generally would use a bookmarklet to translate the current page from whatever language it is in into my own language(English). You can drag the bookmarklet(tr: translate current page) to your bookmarks and invoke it from there (there is nothing on this page that needs translation).

From Richard at Digital.com:
At Digital.com, we've published a "long read" on the rise and fall of Altavista's Babel Fish, which I thought make an "easy fix" to send your readers somewhere more useful than the random redirect to the Yahoo homepage. It covers everything from the birth of the first online translator (and the geek-friendly name!) through to its demise at the hands of Google Translate. You'll find the article here:- https://digital.com/about/babel-fish/

This is an old page, and we were all Microsoft MVPs and many of the sites have changed or disappeared as have Laurent's pages. An example of a site I needed to translate, Laurent Longre's site:
http://longre.free.fr/ (not found)   (not found) automatically from French to English using Babel Fish (not found) (not found)
http://babelfish.altavista.com/babelfish/urltrurl?lp=fr_en&url=http://longre.free.fr/index.html (not found)
 
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 (not found 404) [-- 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é (not found 404) This Excel table also available in HTML format at (not found) « (not found) and is marked courtesy of Laurent Longre (not found)

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 (not found)   get XLmenufundict (not found) «, Jan Karel Pieterse, zip file, available at http://www.oaltd.co.uk/mvp/ (not found) (links within not found) 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

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 (not found) updated (English only) for Excel 2000-2003 http://www.rondebruin.nl/id.htm (not found) 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 (not found)

Related

• MSKB 69529 -- Description of How International Macros Work in Excel (not found)  Excerpt from this page:In Excel, International Macro contents (both functions and text strings) are always displayed in English with U.S. country settings.  No translation is performed when loading the macro sheet in a different language version of Excel. That article is missing but this article by John Green and Stephen Bullen is probably better and is based on material prepared by Stephen Bullen -- International Issues: Part II (Microsoft Office and VBA Developer 2000) (not found)
• Look up "multilingual" in Excel HELP, particularly look at topic "About multilingual features in Office".
• Excel Cheatsheet (not found) may help you with what’s available or how to start using a feature. (& PDF format)
• List of 339 Worksheet Functions (not found) « in French, English, Spanish, German, Portuguese (Brazilian), Dutch, Swedish, Italian, Finnish -- on Christian Herbé’s site [ Babelfish French to English] (not found), Courtesy of Laurent Longre (not found). [ Babelfish French to English] (not found)].

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

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