Language Translation in Excel

[[email protected]]

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=stemmed&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

[Pete_UK]

I can't see where your 'XXXXXX' fits into the formula, but essentially
you could replace this with a cell reference joined in with the rest of
the formula, something like:

("http://www.ultralingua.net/index.html?action=define&sub=1&nv=0&search="&A1,"ultralingua").

Hope this helps.

Pete

[[email protected]]

Thanks Pete

Yes I've got this to work. I was expressing the formula in the
hyperlink incorrectly.

Thanks again

[[email protected]]

Thanks Pete

Yes I've got this to work. I was expressing the formula in the
hyperlink incorrectly.

Thanks again

[Pete_UK]

Thanks for the feedback - glad you got it working.

Pete

[dcdonahue]

Hi Rob,

Did you get the translated phrase/word to automatically show in column B or do you have it showing the hyperlink "ultralingua"?

I also have to translate word lists for work be very at ~2500-4000 words and it would useful to insert one cell double click down.

Daniel

[arlu1201]

dcdonahue,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.