Text
Excel 365
◉ 9 views
=TRANSLATE()
The TRANSLATE() function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel Mobile
=TRANSLATE(text, [source language], [target language])
Hover argument names in the table for details.
Output typeText
Popularity25 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =TRANSLATE() 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)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
text |
Text | Optional | The text to translate. This value should either be enclosed in quotation marks or be a reference to a cell containing the appropriate text. |
source_language |
Text | Optional | (optional): The language code of the source language (e.g., "en" for English or "es" for Spanish). If not specified, the language will be automatically detected based on the text provided. Auto-detection is supported for most languages. For the full list, check Supported Languages and Language Codes. It is recommended to specify the language if known, especially for shorter texts. |
target_language |
Text | Optional | (optional): The language code of the target language (e.g., "en" for English or "es" for Spanish). If not specified, the system language will be used as the target language. |
▣ Examples
Example 1
=TRANSLATE(A1, "en", "es")
💬 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!