DETECTLANGUAGE

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.

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 .

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
13217388180461864977
true
Search Help Center
true
true
true
true
true
35
false
false