GOOGLETRANSLATE with Arrayformula?

[Lucas_Pires]

@ThinhDinh take a look in this formula

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”), “.”))))