The result from DETECTLANGUAGE is a short language code indicating the language.
Some of these codes are intuitive, but some aren’t.
See below for a list of common language codes.
The DETECTLANGUAGE function uses Microsoft Translation Services, so it requires an internet connection.
Basic Example
To use the DETECTLANGUAGE function, simply provide some text.
The TRANSLATE function supports over 100 languages, so there aremanypotential codes.
See below for a list of common languages and codes.
The goal is to determine the language codes based on the text in column B.
To learn more see ourExcel Table guide.
Note that some languages, like Portuguese, have more than one variant.
The DETECTLANGUAGE function supports over 130 languages.
you’re free to find the full list of supported languageshere.
The source and target languages are provided as special codes.
