Requirement: Translating Text with the functions using the language code
For Translating Text from one language to other using google translate in excel
=GOOGLETRANSLATE(A5,"fr","en")
=GOOGLETRANSLATE translates text
Text= text to translate
Source_lang= language translating from
Target_lang= language translating to
Do the same Process for remaining cells. Instead of going and searching in google for translation use this trick