![Using Google Translate in Google Sheet [2024] Using Google Translate in Google Sheet [2024]](https://m5.paperblog.com/i/761/7619144/using-google-translate-in-google-sheet-2024-L-1Jge5l.png)
With my copy in column B, starting in cell B2, and with the language short codes “en” for the original language and “no” for Norwegian – what I want to translate the English into, in cells E1 and F1 respectively, the code I place in cell D2 is:
=GOOGLETRANSLATE(B2,$E$1,$F$1)
I can drag the formula down to translate all the English in column B.
That’s it really
![Using Google Translate in Google Sheet [2024] 🙂](https://m5.paperblog.com/i/761/7619144/using-google-translate-in-google-sheet-2024-L-QuGAZH.png)
By the way – if you have a site that’s randomly in 2 languages, or more – you can use detect language Google Sheets function
=DETECTLANGUAGE(“cellnumber”)