Excel 2007 function name translations

I

ipex21

New Member
Joined
Nov 6, 2008
Messages
2
Hi,

for people using their Excel in other languages than English - Excel 2007 functions and their descriptions in 14 languages:

http://www.piuha.fi/excel-function-name-translation/

Why? I needed an updated look-up table because at home I'm using my Excel 2007 in Finnish and I don't have a English Language Pack. I noticed that most of the function dictionaries are quite old (Excel 4.0/97) and first I compiled a Finnish-English-Finnish -dictionary from Microsoft's function reference.

Then it got out of hand and I added 12 other languages :) Freely available to view or download if you like.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
ipex,

Welcome to the board. That is most interesting. Thank you.

To all: the languages available are:

Czech (čeština)
Danish (dansk)
Dutch (nederlands)
Finnish (suomi)
French (français)
German (deutsch)
Hungarian (magyar)
Italian (italiano)
Norwegian (norsk)
Polish (język polski)
Portuguese (português)
Spanish (español)
Swedish (svenska)

I am interested to learn what process you used to pull this info from Excel. Did you create a template with all of the functions and then switch the operating system language settings?
 
Upvote 0
Hi Greg, how do you do?


A small contribution that I think it would work within Excel in any language. It´s not general,
but it has worked for me so far.

Due I use Office 2007-Spanish version, sometimes looking to solve some problems I´ve found on
the internet formulas related with what I looking for, but in English. The thing is that sometimes
I don´t know what would be the correct function to use in the Excel´s Spanish version, so what
I´ve done before to translate is write a small VBA code with the function to execute in any cell,
then I run the code and when I get back to the Excel sheet I can see the result of the function
written in VBA but with the name in Spanish.

In VBA mode F2-->Application-->Worksheet.Function-->Function wanted

A little example below:

Code in english
Rich (BB code): 
Sub Translate_Functions()
 
    Range("A1").Formula = "=RAND()"
    Range("A2").Formula = "=SUM(1, 2)"
 
End Sub

Result in sheet (now in Spanish)

In A1-->fx=ALEATORIO()
In A2-->fx=SUMA(1,2)

Best regards.
 
Upvote 0
¡Gracias César! :-) Había visto a Héctor Miguel usar ese truco un par de veces. Pero no lo memoricé y por solo correr Excel en inglés no tenía como experimentar para tratar de descubrirlo yo cómo era exactamente.

EDIT - César threw me off -- I forgot we were running this thread in English. I'd seen this trick done by Hector Miguel, but didn't memorize which way it went. Type English in cell and inquire in VB editor or vice-versa? And since I only use Excel in English, I didn't have any means of playing around and discovering it on my own.

Saludos,
 
Last edited:
Upvote 0
Nice tip, Carlos! One week ago another Carlos from Brazil sent me an email that also Brazilian Portuguese has many function names that differ from Portuguese from Portugal :)

I have added Brazilian Portuguese to the Excel function dictionary.
 
Upvote 0
I while ago I made a quick and dirty '07 add-in to translate between local language setting and English for my own use. A tiny bit of work - mainly adding a commandbar - will make it suitable for '03 and earlier. Anyone interested pop me a PM with your mail and I'll have it over.
 
Upvote 0
I accept: Due I use Office 2007-Spanish version, sometimes looking to solve some problems I´ve found on
the internet formulas related with what I looking for, but in English. The thing is that sometimes
I don´t know what would be the correct function to use in the Excel´s Spanish version, so what
I´ve done before to translate is write a small VBA code with the function to execute in any cell,
then I run the code and when I get back to the Excel sheet I can see the result of the function
written in VBA but with the name in Spanish.

In VBA mode F2-->Application-->Worksheet.Function-->Function wanted
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
run VBA when clicked
Replies
4
Views
142
Gylle
G
Jaafar Tribak
  • Question Question
Referencing all Running Instances Of Excel, Word and Access
2 3 4
Replies
32
Views
1K
Jaafar Tribak
Jaafar Tribak
J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
376
Jagadeshrao
J
M
  • Question Question
Excel Time Keeping "Application"
Replies
0
Views
556
Mrock1
M
T
  • Question Question
Excel Translate from English Language to Others via VBA Code
Replies
3
Views
9K
John_w
J

Forum statistics

Threads
1,224,548
Messages
6,179,445
Members
452,915
Latest member
hannnahheileen

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top