Does Excel TRANSLATE Translate Formulas or Only Text?

Excel’s TRANSLATE() function translates text, not formula syntax. It can convert a phrase in a cell from one natural language to another, but it does not convert localized function names, argument separators, cell references, or workbook logic. To change an English formula such as IFERROR(SUM(...),0) into German formula syntax, use a formula-aware translation workflow instead.

The two jobs sound similar because both use the word “translate,” but their inputs and outputs are fundamentally different.

What Excel TRANSLATE does

Microsoft documents the function with this syntax:

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

The required text argument is a quoted value or a reference to a cell containing text. The optional language arguments use language codes. If the source is omitted, the service can attempt detection; if the target is omitted, Excel uses the system language.

If cell A1 contains Good morning, this formula requests a German translation:

=TRANSLATE(A1,"en","de")

The result is translated text in the cell where the formula is entered. The TRANSLATE call itself remains an Excel formula; it is the value from A1 that goes to Microsoft Translation Services.

As of this article’s review on September 14, 2026, Microsoft’s TRANSLATE documentation lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, and Excel Mobile under “Applies To.” Microsoft also labels it a service-backed function, so supported languages and results can change.

What TRANSLATE does not change

TRANSLATE() is not an Excel formula parser. It does not intentionally identify or preserve:

• localized function names such as German WENN and English IF;
• commas or semicolons used as function argument separators;
• decimal punctuation or array-constant structure;
• cell, range, sheet, table, or workbook references;
• error tokens such as #NAME?; or
• whether a function exists in a particular Excel version.

Passing formula text to a natural-language translation service is therefore unsafe. A service might translate words inside quoted labels, leave function names unchanged, change punctuation, or produce prose that is not valid Excel syntax. It has no obligation to preserve the grammar of a working formula.

Formula localization is a separate conversion

Consider this English formula:

=IFERROR(SUM(A1,B1),0)

A typical German-localized form is:

=WENNFEHLER(SUMME(A1;B1);0)

That conversion requires structured knowledge. IFERROR maps to WENNFEHLER, SUM maps to SUMME, and argument commas become semicolons while references and numbers remain unchanged.

The Excel Formula Translator performs this narrower operation in the browser using bundled formula mappings. It treats the input as formula text, protects quoted strings and reference structure, and reports unknown or unavailable functions. It does not send the formula to Microsoft Translation Services or calculate the workbook.

For the full process, see how to translate Excel formulas between languages. The separator guide explains why replacing every punctuation mark is not sufficient.

Use both tools for a bilingual worksheet

A workbook may need both natural-language translation and formula localization, but keep the steps separate.

Imagine A2 contains an English product description and B2 contains a formula calculating its status. A German-facing workbook might use:

=TRANSLATE(A2,"en","de")

to produce German description text. Separately, the status formula may appear in German Excel as:

=WENN(C2>0;"Auf Lager";"Nicht verfügbar")

Here TRANSLATE handles the content value. Formula localization handles IF/WENN and the separators. The quoted labels "Auf Lager" and "Nicht verfügbar" are worksheet content chosen by the workbook author; a formula translator should not silently rewrite them.

If the workbook itself is shared, Excel may display supported stored formulas in each user’s language automatically. Raw formula text copied through email, a web page, VBA, or CSV still needs deliberate conversion. The guide to automatic cross-language formula behavior explains that distinction.

Understand the service and privacy boundary

Microsoft states that TRANSLATE() uses Microsoft Translation Services and is service-backed. That means its operation depends on an external service rather than only the local calculation logic normally associated with simple arithmetic functions.

Before using it for business data, follow your organization’s policy for external services and avoid assuming every cell is suitable for translation. Consider whether the text contains personal information, confidential notes, internal identifiers, or regulated data. The function is useful for ordinary labels and content, but data governance is a workbook-owner decision.

This site’s formula converter has a different boundary: formula text is processed locally in the browser. That local conversion is possible because it maps known syntax rather than generating a natural-language translation. It still cannot verify workbook permissions, named ranges, or calculation results.

Availability and common errors

Because TRANSLATE() is currently listed for Microsoft 365 and mobile products, do not assume it exists in Excel 2013 or Excel 2010. A recipient without support for the function may see a compatibility marker or #NAME?. Check the current Microsoft “Applies To” list before distributing a dependent workbook.

Microsoft also documents several service-specific failures: text can be too long, the input may not be text, a language code may be invalid or unsupported, and requests can be throttled after a daily quota is exceeded. Those conditions are different from formula-localization warnings such as an unknown function mapping.

If the workbook shows _xlfn, use the Excel compatibility repair guide rather than translating the visible prefix. A missing TRANSLATE() implementation cannot be supplied by changing separators.

Choose the right tool

Use Excel TRANSLATE() when you need to translate:

• a sentence, label, description, or other text value;
• text from a referenced cell; and
• supported natural languages through Microsoft’s service.

Use formula translation when you need to convert:

• localized Excel function names;
• function argument separators;
• supported localized errors or special arguments; and
• formula text copied between Excel language environments.

Use neither as a substitute for workbook testing. Natural-language output needs human review for context, while localized formula output must be calculated in the destination Excel version. Once the input is classified as content or syntax, the correct translation path becomes straightforward.