Another new function that can work in tandem with translate is detectlanguage. Read more about translate here.
It does exactly what is says, it will detect the language of text and return a two letter code for the language found.
There is only one input required for the function and that is the text to be detected. This can either be in a cell that you reference or typed directly into the function. For example, detectlanguage(“hello”) returns en for English. detectlanguage(B5) will return the code for the language in cell B5. If there is no text there you will get a blank cell, and numbers seems to return en.