Updated post here: https://werkify.blogspot.com/2023/02/translate-text-in-google-sheets-using-the-googletranslate-formula.html Having a hard time to translate text in Google Sheets? Here is a tip on how you can do it. GOOGLETRANSLATE Function Syntax GOOGLETRANSLATE(text, [source_language, target_language]) - text ~ the cell (text) you want to translate - source language ~ the original language of the text; if you don't know you can use "auto" - target language ~ the language you want the text to be translated ( language code usually start with the first two letters e.g. English ~ "en" , Korean ~ "ko" ) Is your language supported? Browse the list of Google Translate Supported Language . Translate My Sheet Add-on Translate My Sheet This simple Google Add-on allows you to translate your spreadsheet in more of 100 languages! Two options are available: - Translate your selected range ...
Blog about the latest digital trends, technical know-how in software and application, and what's new in technology.