Using Google Translate in Google Sheet [2024]
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
By ...