google-sheetslocalizationgoogle-sheets-formula

Google preadsheet GOOGLETRANSLATE uppercase results


I notice GOOGLETRANSLATE when used with capital letters gives wrong results.

Is there a way (using formulas) to make it ignore capital letters and translate everything as it were lowercase?

I am using this formula:

    =IF(B8="",,GOOGLETRANSLATE(B8,"en","hr"))

Samples:

"Lyrics" translated stays "Lyrics" while is should be "Tekstovi pjesama"

If I use lowercase lyrics, then its correct.


Solution

  • As per you modification example you need LOWER() function to convert all the characters to lowercase. Try-

    =GOOGLETRANSLATE(LOWER(B8),"en","hr"))
    

    For dynamic spill array try MAP() function like-

    =MAP(TOCOL(B8:B,1),LAMBDA(x,GOOGLETRANSLATE(LOWER(x),"en","hr")))
    

    enter image description here