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.
Flubaroo is a third-party extension for Sheets that can help make grading classroom papers fast and easy. Here's a quick ...
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 MoreNamed ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.
Discover MoreThere are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Copyright © 2018 Sharon Parq Associates, Inc.
Comments