Excel Translation from Spanish to English

nmk34

New Member
Joined
Apr 12, 2022
Messages
46
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
 
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:

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

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

Bests regards,

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

This VBA code uses Google Translate:

 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top