DETECTLANGUAGE identifies the language used in text within the specified range.

Sample Usage

DETECTLANGUAGE(A2:B7)

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 .