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.
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")))