Home › Functions › Text › =DETECTLANGUAGE()
Text Excel 365 ◉ 17 views

=DETECTLANGUAGE()

With the DETECTLANGUAGE() function, you can easily identify the language used in a specified text or range. This function uses Microsoft Translation Services.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel Mobile
=DETECTLANGUAGE(text)
Hover argument names in the table for details.
Output typeText
Popularity10 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =DETECTLANGUAGE() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download DETECTLANGUAGE.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
text Text Optional The text or reference to cells containing text to evaluate.

▣ Examples

Example 1 =DETECTLANGUAGE(A1)

⇄ Related Functions

=IF() How to use the IF function in Excel to make logical comparisons between data values. =TRANSLATE() The TRANSLATE() function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.