Description
The TRANSLATE() function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services.
Note: This function is a service backed function. The supported languages and results may vary as languages are added or removed.
This article describes the formula syntax and usage of the TRANSLATE function in Microsoft Excel.
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.
