ExcelExcel Microsoft 365+
DETECTLANGUAGE function in Excel
Identifies the language of a specified text
=DETECTLANGUAGE(text)DETECTLANGUAGE syntax and parameters
One argument, one required.
- textstringRequired
DETECTLANGUAGE examples
Formulas you'll actually reuse.
The language code of a customer review:
=DETECTLANGUAGE(A2)Result
"de"Route non-English comments to a translation queue:
=IF(DETECTLANGUAGE(A2) = "en", A2, "Needs translation")
DETECTLANGUAGE in Google Sheets
Same name — your formula ports as-is.
Try DETECTLANGUAGE in the playground
Edit the example — nothing to install.
Preloaded with the DETECTLANGUAGE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ARRAYTOTEXTReturns an array of text values from any specified rangeTextNo Google Sheets equivalent
- CHARReturns the character specified by the code numberTextGoogle Sheets
- CLEANRemoves all nonprintable characters from textTextGoogle Sheets
- CODEReturns a numeric code for the first character in a text stringTextGoogle Sheets
- CONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.TextGoogle Sheets
- CONCATENATEJoins several text items into one text itemTextGoogle Sheets