This article describes the formula syntax and usage of the DETECTLANGUAGE function in Microsoft Excel.
Description
With the DETECTLANGUAGE() function, you can easily identify the language used in a specified text or range. This function uses Microsoft Translation Services.
Syntax
The syntax for the DETECTLANGUAGE() function is as follows:
=DETECTLANGUAGE(text)
The function has the following arguments:
-
text - The text or reference to cells containing text to evaluate.
The supported languages and their respective language codes can be found: Supported Languages and Language Codes
Example
Suppose you have the following text in cell A1: "Hola mundo!" and you want to find out what the language of the text is. You can use the DETECTLANGUAGE() function as follows:
=DETECTLANGUAGE(A1)
This will return the detected language for the text in cell A1. The language code "es" for Spanish will be displayed in the cell where you entered the formula.
Common Errors
You have too many characters in a cell. Reduce your cell size and try again.
You have a non-text value in your cell. The function only accepts a text argument.
