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-07T16:20:46+00:00

    Hi, I'm Elise, an independent advisor and I'd be happy to help with your issue.

    Unfortunately there isn't a direct equivalent of the GOOGLETRANSLATE function in excel without third party add-in, the closed function which I see you have already tried is: https://support.microsoft.com/en-gb/office/exce...

    Please let me know if you need any further assistance.

    Kind Regards,

    Elise

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-04-07T17:58:43+00:00

    #2

    Excel has a "translate" feature but it seems like it has been intentionally dummied down to not work in formulas. Is that true?

    #1

    Can a formula be used in Excel to translate text from one language to another using the Bing Translate database? 

    #1

    No. Excel does not have that sort of function.

    #2

    The "translate" function addin is used to translate the elements of a formula/function from one language to another, not to translate text values between languages.

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2021-04-15T03:44:02+00:00

    Thank You. I found a workaround using a document translate feature in word.

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2021-04-15T03:45:37+00:00

    Thanks. I was able to translate in bulk by putting the words in a word doc and using the translate document feature.

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2021-04-15T04:29:39+00:00

    If you are willing to work outside of Excel, then there are also online translation tools like "Google translate".

    0 comments