Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The DETECTLANGUAGE function is used to identify the language of a given text. This can be useful for applications that need to process or analyze text in different languages.
Syntax
DETECTLANGUAGE(text)
The DETECTLANGUAGE function syntax has the following arguments:
- text Required. The text for which you want to detect the language.
Example
| Formula | Description | Result |
| =DETECTLANGUAGE("Bonjour") | Detects the language of the word "Bonjour". | fr |
| =DETECTLANGUAGE("Hello") | Detects the language of the word "Hello". | en |
| =DETECTLANGUAGE({variable}) | Assuming {variable} contains "Hola", this detects the language of "Hola". | es |
Errors
For a full list of formula errors, please read Formula errors.