Excel Translation from Spanish to English

[nmk34]

Hello
I have a column in a sheet that keep getting more rows with comments in Spanish. I do not understand Spanish that well and would like to add another column next to it where this column will have English translation.
How to do that?
I tried the translator in Excel, and i have close the translation inteface and reopen it for every row of text to translate. the other problem, for every text to translate i have to select FROM ("Spanish") and TO ("English"), very long and not productive. please help

 

[coulombevin]

Hi nmk34,

In excel 365, which is one of the version you have in your profile, you could use this to translate text from spanish to english:

=TRANSLATE($A2:$A,"es","en")

If the spanish text is in a comment buble then I would look into VBA.

Bests regards,

Vincent

 

[John_w]

If the Spanish text is in a comment bubble then I would look into VBA.

This VBA code uses Google Translate:

Google Translate Macro Function - How to rafear to Cell and/or Text in Quotes?

Hello experts, i modify actual script to create a function in Excel to translate from Google Translator with formula. In order to work, you need to add Reference "Microsoft Internet Controls" (Tools>References) I create it referring to a cell range value with syntax...

www.mrexcel.com