TRANSLATE
Translates a text from one language to another.
TextModern Excel FunctionsText Processing
What it does
Translates text using Microsoft Translator service.
Syntax
TRANSLATE(text, [source_language], [target_language])
Arguments
text(text) — Text to translate.source_language(text) — Code (e.g. 'en').target_language(text) — Code (e.g. 'es').
Examples
Translate
Translate 'Hello' to Spanish.
FORMULA
=TRANSLATE("Hello", "en", "es")RESULT
Hola
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Hello |