You've probably used Google's translation site before in order to do elementary translations from one language to another. (You can find it by visiting http://translate.google.com.) Now Sheets brings the power of Google Translate directly into your spreadsheet. All you need to do is use the GOOGLETRANSLATE FUNCTION, in this manner:
=GoogleTranslate(A1, "en", "es")
In this example, the function returns a translation of whatever is in cell A1 from English ("en") to Spanish ("es"). You could, if you wanted, also provide cell references for the source language and the target language:
=GoogleTranslate(A1, A2, A3)
When specifying a source and target language, use the two-character designation for langauges. Some of the more common designations are en (English), sp (Spanish), fr (French), ja (Japanese), ko (Korean), etc. You could, if desired, also tell Google to figure out what the source language is, in this manner:
=GoogleTranslate(A1, "auto", A2)
This example translates whatever is in cell A1 (after Google figures out what language it is) into whatever language you specify in cell A2.
There are times when you don't want to mess up a spreadsheet, but you want to try out some changes. This is when making a ...
Discover MoreTo present your spreadsheet data in just the manner you want, Sheets provides tools that enable you to adjust both ...
Discover MoreWhen you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. If you don't ...
Discover MoreThere are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Copyright © 2021 Sharon Parq Associates, Inc.
Comments