View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Language Translation in Excel

Hi

I wonder if anyone can help me with this.

I have a list of English words (about 2500) that are listed in excel in
column A. In column B I'd like the Portuguese translation.

The best I've got so far is to have a hyperlink in column B -
=HYPERLINK("http://www.ultralingua.net/index.html?action=define&sub=1&nv=0&searchtype=ste mmed&text=XXXXXX&service=english2portuguese",
"ultralingua").

Where I've typed 'XXXXXX' this is the word that will be translated in
ultralingua.

Is there any way that XXXXXX can be replaced with the contents of a
source cell i.e. so ultralingua translates the contents of one of the
cells from column A? I'll the transcriibe the result into column B.

Thanks