Spushi becomes your own multilingual translator!GoogleTranslate function not found in Excel is super convenient

Spushi becomes your own multilingual translator!GoogleTranslate function not found in Excel is super convenient

  • By huaweicomputers
  • 07/11/2022

 Use the GoogleTranslate function to translate into multilinguals.The syntax is "= GoogleTranslate (text, source language, target language)".

 Specify the text to be translated in [Text].[Source language] specifies the cells that are used in Google Translate in "" (double quotation) or the cells containing the language code.For example, "JA" in Japanese and "en" in English.It is also possible to automatically judge the language by specifying "Auto".In [Target Language], as in [Source language], specify a cell that enters the language code or a cell with a language code.

スプシが自分専用の多言語翻訳機に! ExcelにはないGOOGLETRANSLATE関数が超便利

 Here, I will try translation from the Japanese language to multiple multilinguals.The C2 has a language code used in Google Translate in column B in column B.Language names are entered in column A so that it is easy to understand, but it is not used in function formulas.

C5に「=GOOGLETRANSLATE($C$2,$B$2,B5)」と入力する。関数式をコピーするため、[テキスト]と[ソース言語]のセル参照は絶対参照で指定しているB5にはイタリア語を表す「it」が入力されているため、イタリア語に翻訳された。関数式をC17までコピーする日本語のテキストから多言語へ翻訳できた

 Let's re -enter the translated text.

C2のテキストを入力し直すと、C5からC17までの結果も書き換わる

 If you translate multiple texts into a specific language, it would be better to specify a language code in a function formula.Here, I entered multiple textbooks to be translated in column A and entered the B2 as "= GoogleTranslate (A2," JA "," en ") and copied.

A2からA8には翻訳対象のテキストをしてある。B2に「=GOOGLETRANSLATE(A2,"ja","en")」と入力して、C8までコピーした

 See the Google Cloud page for the language code specified in the argument.The results of the GoogleTranslate function are the same as Google Translate.If you want to repair the translation result, use [Paste only the value] after copying.