How to Use DETECTLANGUAGE() in Google Sheets

Description

Identifies the language used in text within the specified range.

How To Actually Use DETECTLANGUAGE() in Sheets

DETECTLANGUAGE(text_or_range)

Try DETECTLANGUAGE yourself

Use the DETECTLANGUAGE function to identify the language of the text in the range A1:A10. The correct answer must return the language code for each cell in that range.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Better Sheets Tutorial

World Peace in Google Sheets

Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!

Beginner

DETECTLANGUAGE() GOOGLETRANSLATE() VLOOKUP()

Transcript-matched member videos for DETECTLANGUAGE(). Click through to watch.

Watch more tutorials

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your da...

Intermediate

IF() ISBLANK() SUBSTITUTE()

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making applica...