📎 This article includes 1 downloadable practice file ↓
In this article
TRANSLATE uses Microsoft’s translation service to translate text between languages, right in the sheet.
Syntax
=TRANSLATE(text, [source_language], [target_language])| Argument | What it means |
|---|---|
target_language |
Language code such as “hi”, “en”, “ta”. |
Examples
Example 1
=TRANSLATE(B2, "en", "hi")Product names in Hindi for a local catalogue.
💡 It needs an internet connection and sends the text to Microsoft. Do not use it on confidential data.
TRANSLATE in practice
Where you will use it
- Translate product titles for other markets
- Hindi ↔ English customer messages
- Quick multilingual labels
Worked example
| Text | Formula | Result |
|---|---|---|
| Thank you for your order | =TRANSLATE(A2,"en","hi") | आपके ऑर्डर के लिए धन्यवाद |
| Free delivery | =TRANSLATE(A3,"en","hi") | मुफ्त डिलीवरी |
| Easy returns | =TRANSLATE(A4,"en","hi") | आसान रिटर्न |
Microsoft 365 online. Expected output shown, not calculated here: TRANSLATE needs the latest Microsoft 365.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Legal or brand text | Have a person check important translations |
| Recalculation | Copy and paste as values to freeze |
Related functions
DETECTLANGUAGE
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong