ID EN
…
#Dynamic array

TRANSLATE

Excel Functions

Translate text from one language to another

Syntax

EXCEL 
=TRANSLATE(text, [source_language], [target_language])

Arguments

Parameter Description
text The text to translate as a string or cell reference.
source_language [optional] The source language code. Default = auto-detected..
target_language [optional] The target language code. Default = system.

Return Value

Translated text

Details

The TRANSLATE function translates text from one language to another in Excel. To perform a translation, TRANSLATE requires the text to translate and language codes to indicate the source and target language. The syntax for TRANSLATE looks like this: Typically, the text is supplied as a cell reference like A1, but it can also be hardcoded as a string like "apple". While TRANSLATE takes three arguments, only the first argument is required. The other two arguments have the following default behaviors: To use the TRANSLATE function, provide the text to translate, the source language language as a language code, and the desired target language as a language code. For example, to translate the word "apple" into French ("fr"), Italian ("it"), German ("de"), and Spanish ("es"), you can use the TRA

Examples

Example 1

The TRANSLATE function translates text from one language to another in Excel. To perform a translation, TRANSLATE requires the text to translate and l

EXCEL 
=TRANSLATE(text,[source_language],[target_language])
Basic Example

To use the TRANSLATE function, provide the text to translate, the source language language as a language code, and the desired target language as a la

EXCEL 
=TRANSLATE("apple","en","fr")  //  returns "pomme"
=TRANSLATE("apple","en","it")  //  returns "mela"
=TRANSLATE("apple","en","de")  //  returns "Apfel"
=TRANSLATE("apple","en","es")  //  returns "manzana"
Example: Translate text into several languages

In this example, the goal is to translate the text entered in cell C5 into the 9 languages in the table below, using the codes in the range B8:B16 to

EXCEL 
=TRANSLATE($C$5,$B$5,B8)
Example: Translate instructions dynamically

In this example, the goal is to translate instructions dynamically based on the language selected in a dropdown list, as shown in the workbook below.

EXCEL 
=TRANSLATE(B4,"en",target)
Example: Translate instructions dynamically

Below is the XLOOKUP formula in F5:

EXCEL 
=XLOOKUP(D5,languages[Language],languages[Code])

See Also

DETECTLANGUAGE