GOOGLETRANSLATE

Translates text from one language to 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 be translated.

  • 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.