While TRANSLATE takes three arguments, only the first argument is required.

The TRANSLATE function supports over 100 languages.

Seebelowfor a list of codes for some common languages.

Excel TRANSLATE function worksheet example

Note that the TRANSLATE function is dynamic.

If the text in cell B5 is changed, TRANSLATE will generate new translations.

The dropdown list appears in cell F2.

Excel TRANSLATE function worksheet example

For more information about tables, see ourExcel Table guide.

Note that some languages, like Portuguese, have more than one variant.

The TRANSLATE function supports over 130 languages.

Excel TRANSLATE function worksheet example

you could find the full list of supported languageshere.

The result is a language code.

Excel TRANSLATE function worksheet example

Excel TRANSLATE function worksheet example

TRANSLATE function example - dynamically translate instructions

The language dropdown menu is created with a Data Validation list

TRANSLATE function -  language code lookup example

Excel DETECTLANGUAGE function

Excel TRANSLATE function worksheet example

TRANSLATE function -  language code lookup example