Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
Returns the translated text for a text
Syntax
TRANSLATE(from_language, to_language, text)
The TRANSLATE function syntax has the following arguments:
- from_language - Required. The language for the input text.
- to_language - Required. The language to which the text must be translated.
- text - Required. The text which is to be translated.
Example
| Formula | Description | Result |
| =TRANSLATE(en-gb, af-za, good morning) | Translate the text "good morning" from EN-GB (English) to "AF-ZA" (Afrikaans) | goeie more |
| =TRANSLATE("en-gb", "de-DE", "good morning") | Translate the text "good morning" from EN-GB (English) to "de-DE" (German) | Guten Morgen |
Errors
For a full list of formula errors, please read Formula errors.