I'm not aware of any inbuilt translation tool in Excel, so you will
need to build one yourself.

Pete

On Oct 22, 11:06*am, Shadab Malik
wrote:
Dear Pete,

Thanks for your reply but I want the kind of table that you propose to use
VLOOKUP from.

I have phrases in a column and need translation for those in adjacent
column. I dont have any other table with such translation to use. I am
looking for an inbuilt translation tool in Excel. The language that needs
translation is Chinese.

Thanks



"Pete_UK" wrote:
Are the text values made up of single words or phrases? Do you have a
lot of them?

You could set up a table which shows the foreign words in one column
and the translation in the next column and then use VLOOKUP from that
table.

Hope this helps.

Pete

On Oct 22, 6:39 am, Shadab Malik
wrote:
I have a column with text values in a foreign language. Is there a way I can
translate this text to English using a formula / macro / web query such that
all translated values get populated in the adjacent column?

Thanks in advance.

.- Hide quoted text -

- Show quoted text -