TRANSLATE Function in Microsoft Excel: Syntax, Examples & Troubleshooting

=TRANSLATE(text, [source_language], [target_language])

Text is required, as a quoted string or a reference containing text. Source and target are optional language codes, such as en for English and es for Spanish. Microsoft recommends specifying a known source language, particularly for short text. Automatic detection is supported for most, rather than necessarily every, language.

Consult the Microsoft Translator language-support list, checked October 17, 2026. The function is service-backed: language support and exact responses may change, and the individual function page does not establish a fixed daily quota or character limit.

1. Enter Hello, World! in A1.
2. Enter =TRANSLATE(A1,"en","es") in B1 in a supported environment with permitted service access.
3. Microsoft reports the example output Hola mundo!.

This is a documentation-reported expectation, not a fresh result from an invoked service. Translation is not guaranteed to preserve the same capitalization, punctuation or wording in every future service revision. No text was submitted to the backend for this guide.

Keep the source in A1 so someone can review the translation. A plausible result can still lose context, tone or a specialized meaning; a successful formula calculation does not establish professional translation accuracy.

Put en in D1 and es in E1. =TRANSLATE(A1,$D$1,$E$1) requests the same documented translation as the literal-code formula. Absolute code references keep the language pair fixed if the formula is copied down a column.

=TRANSLATE(A1,,"es") instead omits the source-language position while explicitly selecting Spanish. Its first task is source auto-detection. For the clear English sample, translation to Spanish is the intended request, but an identical exact response is not independently certified here.

By contrast, =TRANSLATE(A1) makes both language choices implicit: auto-detected source and system-language target. A colleague using a different system language can therefore receive a different intended target. This is why leaving the defaults implicit can undermine a shared translation sheet.

For a nonconfidential sample list, keep original text, selected source code, selected target code, service result and reviewer approval in distinct columns. Use a blank guard such as =IF(A2="","",TRANSLATE(A2,$D$1,$E$1)) when empty rows should stay empty. The blank branch’s expected output is empty text; it is not a translated sentence.

Do not overwrite source text with the response before review. A translation should be checked by someone qualified for consequential uses such as contracts, medical instructions or formal public statements. The formula has no argument that certifies those uses or locks a particular terminology glossary.

Service use also has a data-sharing consequence. Check organizational rules and the sensitivity of the text before submitting it. This article describes a public demonstration only; it does not authorize sending a workbook’s private content elsewhere.

Microsoft lists Text Too Long, Error in Value for nontext input, Invalid Language for an invalid/unsupported code, and Request Throttled for exceeding the daily translation quota. The page does not provide a complete fixed numeric limit, so none is invented here.

If a function is unrecognized, verify build and service availability. If a request is throttled, repeated bulk attempts may add load without resolving the quota. If security or organizational policy blocks a connection, respect that restriction rather than switching to a different service without approval.

Translation wording is service-dependent. Deterministic worksheet checks can confirm the chosen codes and source references, but they cannot by themselves prove the translated meaning is correct.

Microsoft’s reference checked on October 17, 2026 lists: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel Mobile. Microsoft’s alphabetical catalog, checked October 17, 2026, identifies TRANSLATE with a Microsoft 365 introduction marker. That marker does not establish an exact rollout date, update channel or perpetual-license release. The last functioning version is unverified; no retirement is asserted.

Example verification: Expected numerical results are independently calculated; text and shape expectations follow the documented contract. These examples have not been tested in Microsoft Excel. No screenshot or native execution is claimed.

IF in Excel | ISTEXT in Excel | LEN in Excel

• Microsoft TRANSLATE reference, retrieved October 17, 2026.