GOOGLETRANSLATE

Translates text from one language into another.

Sample Usage

GOOGLETRANSLATE("Hello World","en","es")

GOOGLETRANSLATE(A2,B2,C2)

GOOGLETRANSLATE(A2)

Syntax

GOOGLETRANSLATE(text, [source_language, target_language])

  • text - The text to translate.

    • The value for text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
  • source_language - [ OPTIONAL - "auto" by default ] - The two-letter language code of the source language, e.g. "en" for English or "ko" for Korean, or "auto" to auto-detect the language.

    • If source_language is omitted, target_language must also be omitted.
  • target_language - [ OPTIONAL - system language by default ] - The two-letter language code of the target language, e.g. "en" for English or "ja" for Japanese.

See Also

DETECTLANGUAGE: Identifies the language used in text within the specified range.

Examples

Translates text in the specified range from the source language into the target language.

Was this article helpful?
How can we improve it?