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.