# GOOGLETRANSLATE function **URL:** \ **Category:** Ask for Help\ **Created:** [October 22, 2019, 8:07pm UTC](https://community.glideapps.com/t/googletranslate-function/1339 "2019-10-22T20:07:37Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\ **Post date:** [October 22, 2019, 8:07pm UTC](https://community.glideapps.com/t/googletranslate-function/1339/1 "2019-10-22T20:07:37Z")
Doesn’t GOOGLETRANSLATE function work with ARRAYFORMULA? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 22, 2019, 8:38pm UTC](https://community.glideapps.com/t/googletranslate-function/1339/2 "2019-10-22T20:38:13Z")
Doesn’t looks like it, but this post might have a possible solution. > ---
**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\ **Post date:** [October 23, 2019, 2:17pm UTC](https://community.glideapps.com/t/googletranslate-function/1339/3 "2019-10-23T14:17:42Z")
Unfortunately the informed solution was not helpful ---
**Author:** ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)\ **Post date:** [November 11, 2019, 9:34am UTC](https://community.glideapps.com/t/googletranslate-function/1339/4 "2019-11-11T09:34:34Z")
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”), “.”)))) ---
**Author:** ![Dave\_McManus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave_mcmanus/32/352_2.png) [@Dave\_McManus](https://community.glideapps.com/u/Dave_McManus)\ **Post date:** [November 11, 2019, 6:22pm UTC](https://community.glideapps.com/t/googletranslate-function/1339/5 "2019-11-11T18:22:05Z")
> [@NataliaGo](#): > > ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT( > GOOGLETRANSLATE(TEXTJOIN(". ", 1, A1:A), “RU”, “de”), “.”)))) This is amazing! Thanks @NataliaGo @Jeff_Hager for sharing ---
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [January 1, 2020, 7:41am UTC](https://community.glideapps.com/t/googletranslate-function/1339/6 "2020-01-01T07:41:18Z")
This is not work for ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT( GOOGLETRANSLATE(TEXTJOIN(". ", 1, A:Z), “RU”, “de”), “.”)))) any one can help ?? ---
**Author:** ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)\ **Post date:** [January 1, 2020, 12:09pm UTC](https://community.glideapps.com/t/googletranslate-function/1339/7 "2020-01-01T12:09:26Z")
I made a sample for you, so you could copy paste it. you have at least one mistake, it’s not A:Z, it should be one column. [https://docs.google.com/spreadsheets/d/1j7UL3vS1GiBVUCwkP-89ZXegetjnvPjoIVZXkfvCfNU/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1j7UL3vS1GiBVUCwkP-89ZXegetjnvPjoIVZXkfvCfNU/edit?usp=sharing) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 1, 2020, 3:22pm UTC](https://community.glideapps.com/t/googletranslate-function/1339/8 "2020-01-01T15:22:11Z")
Depending on your country, you may also need to use semicolons (`;`) instead of commas (`,`) in your formulas. ---
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [January 2, 2020, 3:30am UTC](https://community.glideapps.com/t/googletranslate-function/1339/9 "2020-01-02T03:30:12Z")
Thanks ! But When I select range A2:A Error come … "Text result of TEXTJOIN is longer then the limit of 50000 characters. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 2, 2020, 4:40am UTC](https://community.glideapps.com/t/googletranslate-function/1339/10 "2020-01-02T04:40:04Z")
That means you exceeded the limits of Google sheets. The formula creates one long string of characters before splitting it up into separate rows. That string is more than 50000 characters. You may have to restructure your sheet or find a script that will perform the translations.