Learn how to translate text in Google sheet. Will be answering questions too. Can you auto translate in Google sheet, or can you translate a text from another language? We will be mainly focusing on how do I detect language in Google sheet translate? Hence providing answers to How do I automatically replace words in Google sheet? And learn how to detect language to english in Google sheet translate?

This is the formula.

=GOOGLETRANSLATE(A3, "fr", "en")

=GOOGLETRANSLATE(A3, DETECTLANGUAGE(A3), "en")

Let's say you have a foreign language and you have to translate it.
Use a GoogleTranslate() function like this, and the foreign text is easily translated for you.
But what if you are not too sure the origin of the language.

Learn how to translate languages using Google Spreadsheet formula googletranslate().

If you're just curious, below are the list of language code for GoogleTranslate formula.
List of languages support by GoogleTranslate formula.
Language Name Language Code
Afrikaans af
Irish ga
Albanian sq
Italian it
Arabic ar
Japanese ja
Azerbaijani az
Kannada kn
Basque eu
Korean ko
Bengali bn
Latin la
Belarusian be
Latvian lv
Bulgarian bg
Lithuanian lt
Catalan ca
Macedonian mk
Chinese Simplified zh-CN
Malay ms
Chinese Traditional zh-TW
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

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

свернуть