Thursday, 13 February 2020

Google Translate in Sheets


Did you know that you could use google's translate feature in their Sheets application?  Well I didn't until I wanted to translate something and wondered if there was a way.  Turns out there is and it's quite easy.  Check out the image below


In the first column, you have [English] and in the second column, in this case [french], the formula you need to add to B2 would be

=GOOGLETRANSLATE(A2, "en","fr")

Basically translate A2 from english to french.  You could even use other country code languages ja for japanese for example.

Read more here.

https://support.google.com/docs/answer/3093331?hl=en-GB

No comments:

Post a Comment