• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

code for translation

Tom22

Member
Hi,

Just want to check,I have one excel file which is in Spanish, and I want to translate each word mentioned in it to English.

So can we have something which like copy word in current excel and then go to google to translate it and then copy the meaning in English and come back to excel and paste in another sheet in same cell.

Or any other suggestions please.


Thanks in advance
 

Chihiro

Excel Ninja
Depending on version of Excel. It has built-in translation tool.

Go to Options -> Customize Ribbon -> All Commands. It's called "Translate".

Add it to your ribbon or quick command as desired.

61938
 

Tom22

Member
Thanks Chihiro....but the issue is everytime I need to change it to Spanish to English for every new word..and moreover I need translated word in excel which is not possible in above case, as it only shows meaning of that particular word
 

Chihiro

Excel Ninja
There's no built-in tools to paste/replace value with translated word.

You'll need some other tool.

One way to do it, is to paste in range into Word (as text only). Then translate & insert. Copy back into Excel.

Alternately you can use translation API. Though you'll need to find the one that suites your need.
https://tech.yandex.com/translate/
 

Chihiro

Excel Ninja
Oh, I forgot to mention. For axis values, you should really use dimension tables for more control.
 
Top