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 and has support for over 130 languages.
* If "source_language" is left blank, the language will be automatically detected.
* If "target_language" is left blank, the language will be automatically detected.
* If there is no internet connection, then #CONNECT! is returned.
* 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("pizza","en","ar")
2	=TRANSLATE("banana","en","zh-chs")
3	=TRANSLATE("milk","en","cs")
4	=TRANSLATE("football","en","da") = fodbold
5	=TRANSLATE("success","en","nl") = succes
6	=TRANSLATE("balloon","en","en") = balloon
7	=TRANSLATE("late","en","fi")
8	=TRANSLATE("clock","en","de") = Uhr
9	=TRANSLATE("boy","en","hi")
10	=TRANSLATE("beach","en","id") = pantai
11	=TRANSLATE("wine","en","it") = vino
12	=TRANSLATE("train","en","ja")
13	=TRANSLATE("apple","en","ko")
14	=TRANSLATE("cake","en","nb") = kake
15	=TRANSLATE("beer","en","pl") = piwo
16	=TRANSLATE("sun","en","pt") = sol
17	=TRANSLATE("lets go","en","es") = vamos
18	=TRANSLATE("mum","en","sv") = mamma
19	=TRANSLATE("girl","en","th")
20	=TRANSLATE("hello","en","vi") = xin chao

1 - What is the arabic (ar) word for "pizza".
2 - What is the chinese word (zh-chs) for "banana".
3 - What is the czech (cs) word for "milk".
4 - What is the danish (da) word for "football".
5 - What is the dutch (nl) word for "success".
6 - What is the english (en) word for "balloon".
7 - What is the finnish (fi) word for "late".
8 - What is the german (de) word for "clock".
9 - What is the hindi (hi) word for "boy".
10 - What is the indonesian (id) word for "beach".
11 - What is the italian (it) word for "wine".
12 - What is the japanese (ja) word for "train".
13 - What is the korean (ko) word for "apple".
14 - What is the norwegian (nb) word for "cake".
15 - What is the polish (pl) word for "beer".
16 - What is the portuguese (pt) word for "sun".
17 - What is the spanish (es) word for "lets go".
18 - What is the swedish (sv) word for "mum".
19 - What is the thai (th) word for "girl".
20 - What is the vietnamese (vi) word for "hello".