DETECTLANGUAGEIdentifies the language used in text within the specified range.
Sample Usage
DETECTLANGUAGE(A2:A7)
DETECTLANGUAGE(“Bonjour”)
DETECTLANGUAGE(A2)
Syntax
DETECTLANGUAGE(text_or_range)
text_or_range – The text or reference to cells containing text to evaluate.
If text_or_range is specified as a range, it must be a one-dimensional column range.
Notes
If the range specified contains multiple languages, the first text found will be evaluated.
See Also
GOOGLETRANSLATE: Translates text from one language into another.
Examples
Accepts both in-cell string and cell reference as the parameters and returns the language code.
Edge cases .