TRANSLATE function
Summary
Translates a text from one language to another
Syntax
The syntax for the TRANSLATE() function is as follows:
=TRANSLATE(text, [source language], [target language])
The function has the following arguments:
• text: The text to translate. This value should either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• source_language (optional): The language code of the source language (e.g., "en" for English or "es" for Spanish). If not specified, the language will be automatically detected based on the text provided. Auto-detection is supported for most languages. For the full list, check Supported Languages and Language Codes. It is recommended to specify the language if known, especially for shorter texts.
• target_language (optional): The language code of the target language (e.g., "en" for English or "es" for Spanish). If not specified, the system language will be used as the target language.
The function has the following arguments:
• text: The text to translate. This value should either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• source_language (optional): The language code of the source language (e.g., "en" for English or "es" for Spanish). If not specified, the language will be automatically detected based on the text provided. Auto-detection is supported for most languages. For the full list, check Supported Languages and Language Codes. It is recommended to specify the language if known, especially for shorter texts.
• target_language (optional): The language code of the target language (e.g., "en" for English or "es" for Spanish). If not specified, the system language will be used as the target language.
Example
=TRANSLATE(A1, "en", "es")