DETECTLANGUAGE

DETECTLANGUAGE(text)

Returns the language code for the text string provided.

text

The text string to evaluate.

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 there are spelling mistakes the function still returns the correct language code.
* 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
* You can use the TRANSLATE function to return a text string translated into another language.
* This function was first released in July 2024.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=DETECTLANGUAGE("pizza") = en
2	=DETECTLANGUAGE("banana") = en
3	=DETECTLANGUAGE("mleko") = pl
4	=DETECTLANGUAGE("fodbold") = da
5	=DETECTLANGUAGE("succes") = nl
6	=DETECTLANGUAGE("balloon") = en
7	=DETECTLANGUAGE("late") = en
8	=DETECTLANGUAGE("Uhr") = de
9	=DETECTLANGUAGE("boy") = en
10	=DETECTLANGUAGE("pantai") = id
11	=DETECTLANGUAGE("vino") = es
12	=DETECTLANGUAGE("train") = en
13	=DETECTLANGUAGE("apple") = en
14	=DETECTLANGUAGE("kake") = nb
15	=DETECTLANGUAGE("piwo") = pl
16	=DETECTLANGUAGE("sol") = fr
17	=DETECTLANGUAGE("lets go") = en
18	=DETECTLANGUAGE("mamma") = it
19	=DETECTLANGUAGE("girl") = en
20	=DETECTLANGUAGE("Xin chao") = vi

1 - What is the language code for the word "pizza".
2 - What is the language code for the word "banana".
3 - What is the language code for the word "mleko".
4 - What is the language code for the word "fodbold".
5 - What is the language code for the word "succes".
6 - What is the language code for the word "balloon".
7 - What is the language code for the word "late".
8 - What is the language code for the word "Uhr".
9 - What is the language code for the word "boy".
10 - What is the language code for the word "pantai".
11 - What is the language code for the word "vino".
12 - What is the language code for the word "train".
13 - What is the language code for the word "apple".
14 - What is the language code for the word "kake".
15 - What is the language code for the word "piwo".
16 - What is the language code for the word "sol".
17 - What is the language code for the word "lets go".
18 - What is the language code for the word "mamma".
19 - What is the language code for the word "girl".
20 - What is the language code for the word "Xin chao".