Watch the full video below and you can access the exercise file I use in the video and make a copy to your drive to try it for yourself. TRANSLATE SELECTED TEXT with Google Translate where you can edit text and get reverse translation Floating Pop-up Bubble Inline Translator with embedded side-by-side highlighted translation. Just type = DETECTLANGUAGE and the cell with the copy you want to identify in parentheses and it will return the 2 letter code from the table below. Google Translate extension translates text (up to 5,000 characters), words (Dictionary), phrases and webpages using Google Translate service. There is another formula you can use if you don’t know what language is currently being used: =DETECTLANGUAGE(A2) If I wanted to translate copy from Spanish to English I would simply change the formula to: =GOOGLETRANSLATE(C2,”es”,”en”) Detect Language Formula In the example above, I am translating the copy from cell C2 from English to Spanish. You can use the table below to find the two letter language code for each language. Start by adding the cell that contains the copy you want to translate (cell C2 above) followed by a comma, then the 2 letter language code of the language the copy is currently in inside double quotation marks, followed by comma and the two letter language code of the language you want to translate to inside double quotation marks. Google Sheets will populate the rest of the formula. The formula is simple: =GOOGLETRANSLATE(C2,"en","es")įind an empty cell and type =GOOGLETRANSLATE. Try it for yourself Google Translate Formula This was a very tedious process and luckily I found there is a better way the Google translate formula in Google Sheets. I do a lot of QA work for emails in different languages and for a long time I would copy the text, go to the Google Translate website and paste it one by one to get my translations.
0 kommentar(er)
