Excel TRANSLATE Formula Not Working? Fixes That Help

Errors & fixes · Updated November 19, 2026

If Excel’s TRANSLATE formula is not working, first confirm you are using Microsoft 365 or Excel for the web, then check the formula, language codes, and internet connection. With the English text in A2, this formula translates it into French: =TRANSLATE(A2,"en","fr"). For example, “Good morning” should return “Bonjour.”

What the TRANSLATE formula does

TRANSLATE converts text from one language to another inside a worksheet cell. It is useful for translating labels, short notes, product descriptions, or a column of customer messages without opening a separate translation tool for every entry. The result is returned as text in the cell containing the formula.

The function relies on Microsoft translation services, so it is different from a traditional calculation such as adding two numbers: an internet connection and access to connected services may be needed. A formula can therefore be written correctly and still fail to return a translation if the service is unavailable or blocked by a device or organization policy.

Excel also has a separate Translate command on the Review tab. That command opens a translation pane for selected text; it is not the same as a worksheet formula and does not create a cell formula that updates when the source cell changes.

Check the function name and syntax

The syntax is TRANSLATE(text, [source_language], [target_language]). The text argument is required. The language arguments are optional in the function’s syntax, but providing both is usually the clearest way to avoid guessing which language Excel should detect or use as the target.

With the original Spanish sentence in A2, the following formula requests English. For example, if A2 contains “¿Dónde está la estación?”, the result should be a translation such as “Where is the station?” Translation wording can vary, so a different but equivalent phrase is not necessarily a formula error.

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

Use language codes rather than full language names. Common examples include en for English, es for Spanish, fr for French, de for German, and ja for Japanese. Check Microsoft’s current function documentation for supported codes and language pairs if a particular code is rejected; language availability can differ by service.

  • Put text or a cell reference in the first argument.
  • Use the source language code in the second argument and the desired output language code in the third.
  • Put quotation marks around language codes typed directly into the formula.
  • Check that the parentheses and argument separators are balanced and in the right places.

Excel installations using certain regional settings may expect semicolons instead of commas between arguments. If a formula with commas is rejected even though its structure is correct, check the list separator used by your Excel installation. The formula examples here use commas, as in the standard English-language syntax.

Make sure your Excel version supports it

A common reason for a #NAME? error is that the Excel version does not recognize TRANSLATE. The function is documented for Microsoft 365 and Excel for the web. Older perpetual-license releases may not include it, even if they can open a workbook that contains the formula. An unsupported version may show the formula name as unrecognized rather than producing a translation.

In Excel for Windows, check your edition and update status under File > Account. Look at the product information and available update options. If you are using Excel for the web, open the workbook in a browser while signed in to your Microsoft account. On Mac, check the Excel menu’s About or account information and install available Office updates. The exact update controls can depend on how Office was installed or managed.

If a workbook is shared with someone using an older Excel release, ask them to open it in Microsoft 365 or Excel for the web. Otherwise, a formula that works for you may appear as an unsupported function for them. If the formula is unavailable in your version, use Excel’s Review > Translate command for occasional manual translations, or use an approved translation tool and paste the results as values.

Diagnose errors and blank-looking results

The exact message is a useful clue. A #NAME? error usually means Excel does not recognize the function name or part of the formula. Check the spelling, the version, and whether a copied formula contains a typo. A formula displayed literally in the cell, rather than calculated, often means the cell is formatted as text or the entry begins with an apostrophe.

  • Formula appears as text: Select the cell, change its number format to General using Home > Number Format, then edit and confirm the formula again. Changing the format alone may not recalculate a formula already entered as text.
  • Formula is rejected as invalid: Check the parentheses, quotation marks, commas, and language codes. Also check whether your regional settings use a different list separator.
  • Error points to a language argument: Confirm that the source and target codes are supported and that they are inside straight quotation marks when entered as text.
  • Result is not the expected wording: Confirm that the source language is identified correctly. Very short phrases, names, abbreviations, and text mixing languages can be ambiguous.
  • Result does not change after editing the source: Check that calculation is set to Automatic under Formulas > Calculation Options > Automatic. Then select the formula cell and recalculate it.

With the sentence in A2, this example explicitly requests Spanish-to-English translation. If A2 contains only “Banco,” the formula can return a translation based on the selected language pair, but the correct meaning still depends on context: the word can refer to a bank or, in some contexts, a bench.

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

That ambiguity is a translation limitation rather than a spreadsheet calculation problem. Add surrounding words or a full sentence to give the service more context. If the formula returns an error instead of any text, focus first on version support, the arguments, and service access.

Check connectivity and organizational access

Because translation is provided through an online service, temporarily losing internet access can prevent a result from being returned or refreshed. Try opening a normal webpage, then recalculate the formula. If other online features are also unavailable, the issue may be the network, sign-in status, or a temporary service interruption rather than the cell itself.

Work or school administrators may restrict connected experiences or online services in Microsoft 365. A firewall, proxy, privacy setting, or organization policy can also affect access. If the formula works at home but not on a managed work device, ask the administrator whether connected services are allowed. Avoid changing a work privacy or security setting without permission.

If the function worked earlier and has stopped, save the workbook, close and reopen Excel, and check whether the issue affects one formula or every translation formula. A single failing row points more toward its text or language arguments; a whole workbook or multiple users failing at once makes a broader access or service issue more plausible.

Use the formula safely in a column

For a list, keep the source text in one column and put the translation formula beside it. With English text in A2, enter this formula in B2 to request French; “Thank you” should return “Merci.” Then fill the formula down for other rows, checking that each source cell contains the text you intend to translate.

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

Review translations before using them in customer communications, instructions, contracts, health information, or other high-stakes material. Automated translation can miss tone, regional usage, names, technical terminology, and context. A formula producing a plausible sentence does not guarantee a precise or publication-ready translation.

If you need to preserve the current wording rather than keep a live link to the source, copy the translated cells and use Home > Paste > Paste Values. This replaces formulas with their current results. Keep an untouched copy of the source and formulas if you may need to refresh or audit the translations later.

Formula versus Excel’s Translate command

Choose the worksheet function when you need translations in cells, want to fill a formula down a list, or want results to recalculate from source text. Choose Review > Translate when you want to look up selected text manually and do not need a formula in the worksheet. The command’s availability and behavior can depend on the Excel version and connected-service settings.

Neither option is a substitute for human review when accuracy matters. The formula is convenient for drafts, summaries, and routine text, but the Translate pane may be better for a one-off phrase. For confidential information, follow your organization’s rules before submitting text to any online translation service.

Frequently Asked Questions

Why does Excel show #NAME? for TRANSLATE?
Excel may not support the function in that version, or the function name may be misspelled. Try the workbook in Microsoft 365 or Excel for the web, and check that the formula begins with =TRANSLATE.

Does TRANSLATE work without internet?
It depends on access to Microsoft’s online translation service, so an internet connection and permission to use connected services may be required. A network restriction or temporary service problem can stop a correctly written formula from returning a translation.

Can TRANSLATE detect the source language automatically?
The source-language argument is optional, but automatic detection may be uncertain for short, ambiguous, or mixed-language text. Supplying a source code makes the request clearer when you know the language.

Why does the formula show in the cell instead of a translation?
The cell may be formatted as Text, or the entry may have a leading apostrophe. Change the cell to General, then edit and confirm the formula so Excel evaluates it.

Can I use TRANSLATE for an entire column?
Yes. Put a formula next to the first source cell and fill it down, then check that each row points to its corresponding source text. Review the output before sharing or relying on the translations.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.