# Translator

The Microsoft Excel functions have been localized into many languages. If you send your Excel file to someone using a different language for Excel than you, the functions and formulas used in the workbook are automatically translated by Excel when opening the file. However, the automatic translation usually does not work, if you directly insert foreign language formulas into your worksheet. Such a situation may for example occur, if you are using Excel in German and want to use an English formula provided by a forum. The following online tool allows you to translate an Excel formula from one language into another language and therefore use the localized formula.

Hi JMJ,

thank you very much :-)

And thank you for pointing me to the problem with the translation of array formulas.

I am aware of this, but I did not find a reliable solution yet, as this is a bit more complex. This as the array separators are depending from the Excel language

andthe operating system language. Yes, I could use defaults for the OS language, but then it will also depend from in which language Excel is installed. Excel then chooses a dot, a comma or a backslash as array separators. The logic behind this is not fully clear for me, despite some larger tests.I am planning an update of the translator the first quarter next year, including several improvements, such as new languages, functions and more. I hope to be able to find a solution for the array separators then too.

Best,

Mourad