View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shadab Malik[_2_] Shadab Malik[_2_] is offline
external usenet poster
 
Posts: 3
Default translation in Excel 2003

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.


.