Google Sheet 內提供大量Google 獨家的函數,例如Google Finance, Google Translate, 今天分享使用Google Translate 進行繁簡轉換。
使用函數可同時處理多個貯存格的內容,並在其他應用內貼上,方便非常。
函數 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. 如有其他要翻譯的文字可以複制貼上。