GOOGLETRANSLATE function

Hi @Alex_Calandrino, that’s strange that you are saying the solution from the article @Jeff_Hager suggested didn’t work.
I’ve tried the formula below for my file - it translates complete column A from russian to german and it works perfectly.

ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(
GOOGLETRANSLATE(TEXTJOIN(". ", 1, A1:A), “RU”, “de”), “.”))))

8 Likes