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.
As you are developing a spreadsheet, you'll often have the need to insert additional rows into your data. Sheets makes ...
Discover MoreNo longer need a previously defined named range? Here's how to get rid of it.
Discover MoreWhen you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...
Discover MoreThere are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Copyright © 2020 Sharon Parq Associates, Inc.
Comments