The simple formula to translate something within Google Sheets is as follows:
=GOOGLETRANSLATE(B16, “en”, “fr”)
- Here, the ‘B16’ part concerns the reference to the cell containing the text you want to translate.
- After that, you add the source language — the language in which the original text is written — using the language’s abbreviation.
- After that, you declare the target language — the language to which the source text has to be translated — again using that language’s abbreviation.