Share via

Excel translate using a formula

Anonymous
2021-04-07T15:46:53+00:00

Google Sheets allows formulas to translate text from one language to another   =Googletranslate(A2, "en", "es"). Excel has a "translate" feature but it seems like it has been intentionally dummied down to not work in formulas. Is that true? Can a formula be used in Excel to translate text from one language to another using the Bing Translate database?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-04-15T14:53:53+00:00

    I'm working on a professional translation with a teacher and translator. I'm comparing the translation to Google Translate, the translation per Bing, and the professional translation. Google translate seems to be the most accurate for computer generated translation, although Bing translate is pretty good. These translations are critical for the future in terms of working across international borders so I hope both Google and Bing continue to advance their accuracy. By NOT having a formula in Excel, that shows Microsoft does not have a high level of care or investment in this critical area.

    17 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-04-15T16:04:41+00:00

    True there are lots of things that MS "doesn't care about", but think about it.

    .

    Excel is primarily about numbers and calculations, so no translate function is not too surprising.

    On the other hand Word is about words ... and it does have a translate functions.

    .

    Seems like a reasonable separation of powers. 

    .

    3 people found this answer helpful.
    0 comments