使用函數可同時處理多個貯存格的內容,並在其他應用內貼上,方便非常。
函數 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. 如有其他要翻譯的文字可以複制貼上。


