TRANSLATE

TRANSLATE(text, [source_language], [target_language])

Returns the text string translated into another language.

text	The text string to translate.
source_language	(Optional) The language code of the source language.
target_language	(Optional) The language code of the target language.

REMARKS

* This is a Preview Function which means the signature and results may change before being officially released.
* This function was added in Microsoft 365
* This function uses Microsoft Translation Services.
* If "source_language" is left blank, the language will be automatically detected.
* If "target_language" is left blank, the language will be automatically detected.
* link - insider.microsoft365.com/en-us/blog/new-translation-functions-in-excel-translate-and-detectlanguage
* link - learn.microsoft.com/en-gb/azure/ai-services/translator/language-support
* You can use the DETECTLANGUAGE function to return the language code for a text string.
* This function was first released in July 2024.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=TRANSLATE("lets go","en",es") = vamos

1 - What is the spanish word for "lets go".