Google Spreadsheets has two new functions. One will let you auto-translate the contents of a cell. In my sample document containing German quotes in the second column, I used the following function for the third column:
=GoogleTranslate(B2, "de", "en")
i.e.
=GoogleTranslate(text, sourceLanguage, targetLanguage)
That’s potentially very useful I think. The other new function is DetectLanguage, telling you which language a given text has. You can also combine the translation function with other dynamic functions; for instance, in one cell you could use =GoogleLookup("US", "president")* and in another cell reference that result to translate it to Chinese.
[Via Tony.]
*It fails to name the current president, though.
>> More posts
Advertisement
This site unofficially covers Google™ and more with some rights reserved. Join our forum!