Translation in google sheets Posted on 25 May, 2020 by john <span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span> =GOOGLETRANSLATE(A1,”en”,”fr”) Hat tip @TheoKL Works in Glow Blogs too.
Or if you wanted to take a step further =GOOGLETRANSLATE(A1, DETECTLANGUAGE(A1), “en”) via @benlcollins benlcollins.com/google-sheets-… Reply
Or if you wanted to take a step further =GOOGLETRANSLATE(A1, DETECTLANGUAGE(A1), “en”) via @benlcollins benlcollins.com/google-sheets-…