Identifies 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.
- If
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 .