Share via

How to use Microsoft Translate in Excel

Anonymous
2023-01-11T14:04:28+00:00

In Excel I can select a cell and use the "Translate" tool available from the "Review" menu. But the translation is given in a pane to the right of my spreadsheet.

Is there a simple function call where I can make a cell display the translation of another cell?

Like an expression:

=Translate(B3; Spanish)

would translate the contents of cell B3 into Spanish and display in the cell with this expression.

Hope to get some good hints / examples.

Thanks.

Microsoft 365 and Office | Excel | For business | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-11T17:54:05+00:00

    Dear Jake,

    Good day! Thanks for posting in the community. We are happy to help you.

    Regarding your query, currently, there is no such function in Excel. As you mentioned, you may use the Translate feature under the Review tab or use the add-in, like Excel Functions Translator to translate the content.

    Based on the situation, I would like to suggest you vote for the idea in our Microsoft Feedback Portal where other members also voted for a similar idea here. It’s the platform for us to hear your voice and improve our products.

    Appreciate your understanding and patience.

    Sincerely,

    George | Microsoft Community Moderator

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-01-17T03:53:59+00:00

    Dear Jake,

    Sorry for the late reply.

    Regarding your first screenshot, it may belong to a 3rd party add-in or an old interface of a feature. Based on my test, the built-in translator feature or Excel Functions Translator can't translate multiple cells at once, but some 3rd party add-ins seem can meet your requirement. You can search for them in Office Store by clicking the Insert tab> Get Add-ins. Also, please note that these 3rd party add-ins use other online services (like DeepL or Google) to translate cells and require additional purchases. Sorry for the inconvenience that happened to you.

    Appreciate your understanding and patience.

    Sincerely,

    George | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-01-11T19:18:41+00:00

    Hi George,

    thank you for clarifying.

    And - I have just voted for the idea. With now 5 votes, I'm sure it will soon be made available...

    Somehow I guess it may be a tricky routine, as it has to make a web-lookup for each translation. But it could just update cells as it gets the response back.

    Anyway - using the "Translate" function in the Review tab does not give me the option of insert/copy the translation back into my spreadsheet.

    From a YouTube video, I can see that others have this "Insert" dropdown menu. Here the pane on the right is called "Research" and has these extra input fields:

    In my Excel I only get this (and here it's called "Translator"):

    Pasting back the translation is here quite complicated (tiresome...).

    I am running Excel from my Office365 E3. Is there something I need to enable to get "Research" with the "insert" dropdown?

    With this facility I can at least speed up the translation - but is still a lot of work with some 3000 cells to translate.

    Ideally I would have a VBA function where I could parse the text and get the translation back.

    How do I get the "insert" in my Translation pane?

    Thanks.

    Jake

    0 comments