Forum Discussion

Balint79's avatar
Balint79
Brass Contributor
Mar 12, 2024

Formelübersetzer EN >> DE

Hallo Leute, wenn der schnellste(?) Formelübersetzer von EN nach DE gebraucht, der 419 Funktionen kennt... einfach die Zellen markieren und Makro anklicken 🙂
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Mar 13, 2024

Balint79 

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.
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 13, 2024

NikolinoDE 

Unfortunately the site is not up-to-date.

It's missing the latest dynamic array/lambda functions.

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 13, 2024

    Detlef_Lewin 

    That great resource was created and supported by Mourad Louha. One man job. Don't know what happened with him, but he is in silent for about couple of years.

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Mar 13, 2024

    Detlef_Lewin 

    Excel Functions Translator add-in :smile:

    The Functions Translator is geared towards people who use versions of Excel in different languages, and need help finding the right function in the right language, or even translating entire formulas from one language to another.

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Mar 13, 2024

      NikolinoDE 

      The add-in also lacks the newer functions.

       

      • Balint79's avatar
        Balint79
        Brass Contributor
        Mar 13, 2024

        Detlef_Lewin
        thank you, as due to this reply i just checked again my ENDE version and realised that GROUPBY(, PERCENTOF(, PIVOTBY( were still only part of my first Hungarian one. during the update also found an easy way to edit the code structure, attached the latest version.

        from automatisations point of view the approach of "Excel Functions Translator" is still too scattered for me, even the instant functionality is using the pane boxes and can manage only one cell per translation. however i was not asked until now for multi-language version but i would do it via one popup selection list from <100 relevant options like ENDE