Text in Excel: Translate It Into English

Yes—Excel for Microsoft 365 can translate text into English with the TRANSLATE function or the Translate command on the Review tab. If you mean turning a number such as 123 into the written words “one hundred twenty-three,” Excel has no built-in worksheet function for that; it is a different task.

Translate text to English with TRANSLATE

The TRANSLATE function translates text from one language to another and returns the translation in a cell. It is available in Microsoft 365 versions of Excel, including Excel for Windows; it also works in Excel for the web. For a basic translation, provide the cell containing the text, its source-language code, and the target-language code. Use en for English, fr for French, and es for Spanish.

With French text in A2, this formula translates it into English:

With the French word Bonjour in A2, enter =TRANSLATE(A2,"fr","en") in B2. The result is Hello.

It is better to specify the source language when you know it. That avoids relying on automatic detection, which can be uncertain with a short phrase, a name, or text that mixes languages. The target code must identify the language you want returned; the formula does not automatically know that English is your preferred output language.

Translation is not the same as replacing words one by one. A translation service may choose wording based on the phrase and context, and the same source text can have more than one reasonable English rendering. For example, greetings and polite phrases often have natural equivalents that are not literal word-for-word translations.

Set up a column of translated text

For a list, put each source phrase in a separate row and use a neighboring column for the English result. Keep the source text unchanged so you can compare it with the translation, catch mistakes, or rerun the work with another target language. A simple layout might use column A for the original and column B for the translation.

With Spanish phrases in A2:A20, enter this formula in B2 and fill it down through B20:

With Spanish text in A2, enter =TRANSLATE(A2,"es","en") in B2. If A2 contains Buenos días, the result is Good morning.

Each row’s formula should refer to the source cell in that same row. When you fill B2 down, Excel adjusts the reference from A2 to A3, A4, and so on. You can drag the fill handle at the lower-right corner of B2, or copy the formula and paste it into the rest of the output range. Check a few results before sharing or relying on a large batch.

For a workbook that will keep receiving new rows, converting the source range into an Excel table can make the layout easier to maintain. Select the data and choose Insert > Table. When you enter a formula in a table column, Excel generally fills it into the other rows of that calculated column. Keep the original-language column and translated column clearly labeled, such as Original (Spanish) and English translation.

Use the Translate command instead of a formula

A formula is useful when you have many cells or expect the source data to change. For a single passage, Excel’s built-in Translate command can be more convenient. In Excel for Microsoft 365 on Windows, select the cell or the text in the cell, then choose Review > Translate. The Translator pane lets you choose the source and target languages and view the result. The exact controls can vary by app version and the type of content selected.

The command is useful for understanding a phrase without adding a permanent formula column. Depending on the selection and version, you may need to copy the translated result into a worksheet cell yourself. If you do, paste it beside the original rather than over it. Keeping both versions makes review easier and prevents accidental loss of the source text.

If you cannot find Translate, check that you are using a supported Microsoft 365 version and that your organization has not disabled connected experiences. Excel’s menus can differ between Windows, Mac, and the web, and older perpetual-license versions may not include the same function or command. The ribbon’s search box can help locate a command when it is available, but it cannot add a feature that your version does not support.

What Excel translation can and cannot do

Excel can provide a quick machine translation, but the output is not a guarantee of a correct or publication-ready translation. The function does not understand your workbook’s full business context just because neighboring cells contain related information. A product label, legal clause, medical instruction, technical term, or short slogan may need a human translator who understands the subject and audience.

Give particular attention to text that is ambiguous, incomplete, or dependent on local conventions. A short word may have several meanings; a sentence fragment may omit its subject; and a name may be mistaken for an ordinary word. Dates, currency amounts, units, and proper nouns also deserve review. Translation changes language, not the underlying facts, and it does not verify whether a source statement is true.

For customer-facing or regulated material, treat the worksheet result as a draft. Have a qualified person check meaning, tone, terminology, and any required local wording. If a translation must be certified, approved, or legally defensible, a spreadsheet formula is not a substitute for the relevant professional process.

When you mean numbers written out in English

Some people asking about “text in Excel” mean converting a numeric value into words—for example, changing 125 into One hundred twenty-five dollars. That is not translation. Excel does not provide a standard built-in worksheet function that spells out arbitrary numbers in English. The TEXT function formats a number as text, but it does not spell the number out.

With the numeric value 1234.5 in A2, this formula displays it as a formatted amount rather than English words:

Enter =TEXT(A2,"$#,##0.00") in B2. Under English-language formatting conventions, the result is $1,234.50, not One thousand two hundred thirty-four dollars and fifty cents.

For number-to-words output, options include using a reviewed custom VBA function, a trusted add-in, or an external service, depending on your version and workplace rules. Such solutions can differ in wording, handling of cents, large numbers, negative values, and regional conventions. If you use a macro, save a copy of the workbook first: macros cannot be undone with Ctrl+Z. Do not enable or run code from an untrusted source, especially in a workbook containing sensitive data.

Language support, connectivity, and privacy

The TRANSLATE function depends on Microsoft’s online translation service, so it requires a working internet connection and access to connected experiences. A company administrator may restrict those services. If the function returns an error or does not calculate, check connectivity, your Microsoft 365 sign-in, the function’s availability in your Excel version, and your organization’s privacy settings.

Because translation is processed through an online service, consider what text you send. Do not put confidential, personal, or regulated information into a translation workflow unless it is permitted by your organization’s policies and applicable requirements. For sensitive material, consult your administrator or use an approved translation process. An offline workbook alone does not make an online translation request private.

Language codes identify the languages requested, but they do not specify every regional preference or guarantee a particular writing style. If the result needs British rather than American English, for instance, inspect spelling, vocabulary, dates, and units yourself. You can also provide a longer sentence rather than an isolated word when context is necessary, while still avoiding the inclusion of sensitive information.

Common problems and practical checks

If the formula is not accepted, first confirm that the Excel version supports TRANSLATE and that you typed the function name and cell reference correctly. In some regional configurations, Excel expects semicolons as formula separators rather than commas. The formula examples here use the standard comma-separated syntax; follow the separator convention required by your installation if Excel rejects the commas.

If the formula calculates but the translation is unexpected, verify that the source-language code matches the text and that the target code is English. Try a complete phrase instead of a single ambiguous word, and compare the output with a reliable human translation when accuracy matters. A formula can return a plausible-sounding result that is still wrong for the context.

Before distributing a workbook, decide whether the translation should remain formula-driven or become fixed text. A formula can recalculate and may require online access; copied values are easier to read without recalculation but will not update if the original changes. To keep a reviewed translation as fixed text, copy the result cells and use Paste Special > Values. Retain the original text and, where needed, record that the English wording was reviewed.

Frequently Asked Questions

Can Excel automatically translate a whole column into English?
Yes. Put the source text in one column, enter a TRANSLATE formula in the next column with the correct language codes, and fill it down. Review the results, especially for ambiguous or important content.

Does Excel translate text without an internet connection?
The TRANSLATE function uses an online service, so it needs internet access and permission to use connected experiences. If those are unavailable, use an approved alternative or translate the content when access is restored.

Is Excel’s TEXT function the same as TRANSLATE?
No. TEXT formats a number as text—for example, as currency or a date. TRANSLATE converts text from one language to another. Neither built-in function spells a number such as 125 out as English words.

Can Excel translate a number into words in English?
Not with a standard built-in worksheet function. A custom VBA function or a suitable add-in may do it, but check how it handles currency, decimals, and regional wording, and only run code you trust.

Why is TRANSLATE missing or returning an error?
Your Excel version may not support the function, your organization may block connected experiences, or the device may be offline. Check those conditions and confirm that the source and target language codes are valid for the text you are translating.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.