3) Translation – No equivalent in Excel
Yes, you saw that right. Google spreadsheets come with the handy Googletranslate() function which allows you to bulk translate text from one language to another using the Google Translation service. The function itself needs three arguments : (input text, language from, language to). But but I don’t know what language I’m translating from!? No problem, Google docs has a cool function that can do that for you too, it’s called Detectlanguage().
Still to come….
- More fun with arrayformula()
- Splitting, concatenation, transposing
If you know of any other functions / methods you find easier to use in Google docs, please share them in the comments or contact me directly so I can add it to the post. I’ll happily link to you, so please contribute 🙂