The TRANSLATE function of Excel

Last Updated on 30/06/2024
Reading time: 2 minutes

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.

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

  1. Specify the text to be translated or the cell reference with the text
  2. Original language
  3. 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

  1. Select the cell with the text you want to translate
  2. Indicate the original language code. From the context menu, search for the code for French language "fr"
Select the source language
  1. And finally, the language for the translation, "en", "it", "es", .....
TRANSLATE function in Excel

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.

Using language code in the cells

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.

Translation of a long texte with the TRANSLATE function

Leave a Reply

Your email address will not be published. Required fields are marked *

The TRANSLATE function of Excel

Reading time: 2 minutes
Last Updated on 30/06/2024

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.

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

  1. Specify the text to be translated or the cell reference with the text
  2. Original language
  3. 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

  1. Select the cell with the text you want to translate
  2. Indicate the original language code. From the context menu, search for the code for French language "fr"
Select the source language
  1. And finally, the language for the translation, "en", "it", "es", .....
TRANSLATE function in Excel

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.

Using language code in the cells

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.

Translation of a long texte with the TRANSLATE function

Leave a Reply

Your email address will not be published. Required fields are marked *