Spanish translation
Posted by nan on September 19, 2001 10:30 AM
Does anyone know how to translate English into Spanish in Excel? For instance, I have one column of information in English, and the column next to it needs to be translated into Spanish. I have about 8000 lines of information that need to be translated.Thank you for your help.
Posted by Eric on September 19, 2001 11:57 AM
http://www.worldlanguage.com/Products/42588.htm
This stuff is expensive:
http://www.worldlanguage.com/Products/42588.htm
but I know that going from the English to the Spanish version of Excel won't change alphanumerics in columns- just character sets, menu words, and help files (ayudame!)!
There are around 15,000 commonly used words in English and I don't think excel packed a spanish translation feature.
Posted by nan on September 19, 2001 1:17 PM
Re: http://www.worldlanguage.com/Products/42588.htm
Posted by Richard on September 20, 2001 8:32 AM
You could try using macro's and a web query to babelfish or dictionary.com .
Cut and paste the following in notepad and save it with an .iqy extension.
---
WEB
1
http://translator.dictionary.com/fcgi/translate?
text=["TEXTSTRING","Enter word in English"]&lp=en_es
Selection=3
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
---
When you double click on the file, it will open Excel and open a window where it will ask for a cell. Enter the cell you want to take the English source from. Check "Use this value/reference for future refreshes" and "Refresh automatically when cell value changes"
You could now create a macro that copies the English text in your table to this cell and take the result back into your table.
Not sure if you need to do this on a regular basis or if it is a one-time effort, but you have to be careful not to abuse it, since you are using (in this case) dictionary.com's resources.
Also this is not very fast since each query takes about 15-20 seconds to complete.
There might be a better solution to the macro, but I can't think of anything right now.
If someone has better idea, please post it.
Richard
