This article describes the formula syntax and usage of the TRANSLATE function in Microsoft Excel.
Description
The TRANSLATE() function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services.
Syntax
The syntax for the TRANSLATE() function is as follows:
=TRANSLATE(text, [source language], [target language])
The function has the following arguments:
-
text: The text to translate. This value should either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
-
source_language (optional): The language code of the source language (e.g., "en" for English or "es" for Spanish). If not specified, the language will be automatically detected based on the text provided. Auto-detection is supported for most languages, for the full list, check Supported Languages and Language Codes. It is recommended to specify the language if known, especially for shorter texts.
-
target_language (optional): The language code of the target language (e.g., "en" for English or "es" for Spanish). If not specified, the system language will be used as the target language.
The supported languages and their respective language codes can be found: Supported Languages and Language Codes.
Example
Suppose you have the following text in cell A1: "Hello, World!" and you want to translate it to Spanish. You can use the TRANSLATE() function as follows:
=TRANSLATE(A1, "en", "es")
In this example, the source language is English (en) and the target language is Spanish (es). The translated text, "Hola mundo!" will be displayed in the cell where you entered the formula.
Common Errors
You have too many characters in a cell. Reduce your cell size and try again.
You have a non-text value in your cell. The function only accepts a text argument.
You have entered an invalid language code or one we don't support. Please refer to this list for the supported languages: Supported Languages and Language Codes.
You have exceeded your daily quota of the translation function.
