Today I wanted to show you a cool feature I only recently discovered, and it’s in Google Sheets!
You’re not always working in programming languages; sometimes, a simple excel formula can do things quicker.
I often use Excel for quick replacing/searching/comparing, etc.
Today we are looking at translating strings in Google Sheets!
Translate a String in Google Sheets!
So we’ll build a multi-column setup; in column ‘A’, we will have our input words in English. Then in B', we will translate these into Dutch. InC, we'll translate to Spanish, inD, to German, and inE` to Arabic.
So in Google Sheets, Google added the formula GOOGLETRANSLATE. It looks like this:
=GOOGLETRANSLATE(cell with text, “source language”, “target language”)So here is the list of formulas;
Dutch==GOOGLETRANSLATE(A2,"EN","NL")Spanish==GOOGLETRANSLATE(A2,"EN","ES")German==GOOGLETRANSLATE(A2,"EN","DE")Arabic==GOOGLETRANSLATE(A2,"EN","AR")
You can find these two-letter abbreviations on the following page ISO Codes
You can also find an example from my sheet here:
Thank you for reading, and let’s connect!
Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter
