使用函數可同時處理多個貯存格的內容,並在其他應用內貼上,方便非常。
函數 GOOGLETRANSLATE 官方說明
語法
GoogleTranslate(文字, 來源語言,目標語言)
使用範本
GOOGLETRANSLATE("Hello World","en","es")
GOOGLETRANSLATE(A2,B2,C2)
GOOGLETRANSLATE(A2)
支援語言
Language Name | Code | Language Name | Code |
Afrikaans | af | Japanese | ja |
Albanian | sq | Kannada | kn |
Arabic | ar | Korean | ko |
Azerbaijani | az | Latin | la |
Basque | eu | Latvian | lv |
Bengali | bn | Lithuanian | lt |
Belarusian | be | Macedonian | mk |
Bulgarian | bg | Malay | ms |
Catalan | ca | Maltese | mt |
Croatian | hr | Norwegian | no |
Czech | cs | Persian | fa |
Danish | da | Polish | pl |
Dutch | nl | Portuguese | pt |
English | en | Romanian | ro |
Esperanto | eo | Russian | ru |
Estonian | et | Serbian | sr |
Filipino | tl | Slovak | sk |
Finnish | fi | Slovenian | sl |
French | fr | Spanish | es |
Galician | gl | Swahili | sw |
Georgian | ka | Swedish | sv |
German | de | Tamil | ta |
Greek | el | Telugu | te |
Gujarati | gu | Thai | th |
Haitian Creole | ht | Turkish | tr |
Hebrew | iw | Ukrainian | uk |
Hindi | hi | Urdu | ur |
Hungarian | hu | Vietnamese | vi |
Icelandic | is | Welsh | cy |
Indonesian | id | Yiddish | yi |
Irish | ga | 簡體中文 | zh-CN |
Italian | it | 繁體中文 | zh-TW |
STEPS:
1. 預備文字
2. 在B1儲存格鍵入 =GOOGLETRANSLATE(A1,"ZH-CN","ZH-TW")
3. 如有其他要翻譯的文字可以複制貼上。