

We can supply "auto" as the second argument, so that Google will detect the language on its own. In the third example, we see some text in cell A4, but we're not sure what language this is.

This formula returns a result of "This is Japanese!" in English. In the second example we see that the text in cell A3 is written in Japanese and we want to translate it to English. This formula returns a result of "Hello!" in English. We use A2 as the first argument, "es" (the language code for Spanish) for the second argument, and "en" (the language code for English) as the third argument. In the first example, we see that the text in cell A2 is written in Spanish, but we want to translate it to English. Here are some examples of the GOOGLETRANSLATE function in action. Examples with the GOOGLETRANSLATE Function in Google Sheets
