The TRANSLATE function has been added to Excel 365, starting with version 2407. As the name suggests, this function will allow you to translate the text of a cell into another language. For the moment (September 2024), only the Office Insider can access this function.
How to use the TRANSLATE function in Excel?
This new Excel function simplifies the translation technique used until now. Until now, the only effective online translation technique was to use Google translate APIs. But using Google APIs in a formula is not simple. So, the arrival of the TRANSLATE function considerably simplifies the translation process 😉
The function is very simple to use
- Specify the text to be translated or the cell reference with the text
- Original language
- Language of translation
=TRANSLATE(text,source language,target language)
Example to translate
In the following example, we have a list of terms in English. We want to translate them into French
- Select the cell with the text you want to translate
- Indicate the original language code. From the context menu, search for the code for French language "fr"
- And finally, the language for the translation, "en", "it", "es", .....
But you can also write the language code in cells and use the contents of the cells instead of writing the code in the function. If you're not familiar with dollar positioning in a cell, you can learn more with mixed references.
Translating a long text
But this function does not only translate words. It can also translate complete sentences in just a few seconds. It is no longer necessary to use the translation tools on the net or the translation tool in the Revision menu. Here, the translation is extremely fast.
