Google spreadsheet to translate text and detect the language in any of the cells
I was wondering if there is a way to automatically translate the text in spreadsheets. I'm aware about
=GoogleTranslate("text", "source language","target language")formula, but what I need is that in the "text" range I can put the cell range and Google automatically detect the text in that cell. I'm not sure if that's already possible?
Here is the formula:
In the above formula whatever will be the contents of Cell A1 will automatically be detected by Google and then it will be translated into language English.