Translation is crucial for bridging cultural and linguistic gaps, allowing people from different backgrounds to communicate and understand each other. It enables sharing of information and ideas globally, fostering mutual respect and understanding. Additionally, translation supports international business, education, and diplomacy by ensuring clear communication across borders.
Excel has a new TRANSLATE Function, used from and To, over a hundred language. In this tutorial I show you some amazing dynamic uses of the TRANSLATE function for Contract Agreements, Instruction Manuals, Recipes, Greetings Card, Newsletters…. But The sky is the limit… No language barrier anymore.
You can even start a Translation business just with this new Excel Function.
Along the way I show you the DETECTLANGUAGE function as well.
So let’s dive in
#############################################################
Bonus:
Here is a function that allows you to convert numbers to text:
TEXTBEFORE(TRANSLATE(BAHTTEXT(F109))," baht")
################################################################
Here is the list of Codes:
Language Code
Afrikaans af
Albanian sq
Amharic am
Arabic ar
Armenian hy
Assamese as
Azerbaijani az
Bangla bn
Bashkir ba
Basque eu
Bhojpuri bho
Bodo brx
Bosnian bs
Bulgarian bg
Cantonese yue
Catalan ca
Chinese lzh
Chinese Simplified zh-Hans
Chinese Traditional zh-Hant
chiShona sn
Croatian hr
Czech cs
Danish da
Dari prs
Divehi dv
Dogri doi
Dutch nl
English en
Estonian et
Faroese fo
Fijian fj
Filipino fil
Finnish fi
French fr
French (Canada) fr-ca
Galician gl
Georgian ka
German de
Greek el
Gujarati gu
Haitian Creole ht
Hausa ha
Hebrew he
Hindi hi
Hmong Daw (Latin) mww
Hungarian hu
Icelandic is
Igbo ig
Indonesian id
Inuinnaqtun ikt
Inuktitut iu
Inuktitut (Latin) iu-Latn
Irish ga
Italian it
Japanese ja
Kannada kn
Kashmiri ks
Kazakh kk
Khmer km
Kinyarwanda rw
Konkani gom
Korean ko
Kurdish (Central) ku
Kurdish (Northern) kmr
Kyrgyz (Cyrillic) ky
Lao lo
Latvian lv
Lithuanian lt
Lingala ln
Lower Sorbian dsb
Luganda lug
Macedonian mk
Maithili mai
Malagasy mg
Malay (Latin) ms
Malayalam ml
Maltese mt
Maori mi
Marathi mr
Mongolian (Cyrillic) mn-Cyrl
Mongolian (Traditional) mn-Mong
Myanmar my
Nepali ne
Norwegian nb
Nyanja nya
Odia or
Pashto ps
Persian fa
Polish pl
Portuguese (Brazil) pt
Portuguese (Portugal) pt-pt
Punjabi pa
Queretaro Otomi otq
Romanian ro
Rundi run
Russian ru
Samoan (Latin) sm
Serbian (Cyrillic) sr-Cyrl
Serbian (Latin) sr-Latn
Sesotho st
Sesotho sa Leboa nso
Setswana tn
Sindhi sd
Sinhala si
Slovak sk
Slovenian sl
Somali (Arabic) so
Spanish es
Swahili (Latin) sw
Swedish sv
Tahitian ty
Tamil ta
Tatar (Latin) tt
Telugu te
Thai th
Tibetan bo
Tigrinya ti
Tongan to
Turkish tr
Turkmen (Latin) tk
Ukrainian uk
Upper Sorbian hsb
Urdu ur
Uyghur (Arabic) ug
Uzbek (Latin) uz
Vietnamese vi
Welsh cy
Xhosa xh
Yoruba yo
Yucatec Maya yua
Zulu zu
Language Code
Afrikaans af
Albanian sq
Amharic am
Arabic ar
Armenian hy
Assamese as
Azerbaijani (Latin) az
Bangla bn
Bashkir ba
Basque eu
Bhojpuri bho
Bodo brx
Bosnian (Latin) bs
Bulgarian bg
Cantonese (Traditional) yue
Catalan ca
Chinese (Literary) lzh
Chinese Simplified zh-Hans
Chinese Traditional zh-Hant
chiShona sn
Croatian hr
Czech cs
Danish da
Dari prs
Divehi dv
Dogri doi
Dutch nl
English en
Estonian et
Faroese fo
Fijian fj
Filipino fil
Finnish fi
French fr
French (Canada) fr-ca
Galician gl
Georgian ka
German de
Greek el
Gujarati gu
Haitian Creole ht
Hausa ha
Hebrew he
Hindi hi
Hmong Daw (Latin) mww
Hungarian hu
Icelandic is
Igbo ig
Indonesian id
Inuinnaqtun ikt
Inuktitut iu
Inuktitut (Latin) iu-Latn
Irish ga
Italian it
Japanese ja
Kannada kn
Kashmiri ks
Kazakh kk
Khmer km
Kinyarwanda rw
Konkani gom
Korean ko
Kurdish (Central) ku
Kurdish (Northern) kmr
Kyrgyz (Cyrillic) ky
Lao lo
Latvian lv
Lithuanian lt
Lingala ln
Lower Sorbian dsb
Luganda lug
Macedonian mk
Maithili mai
Malagasy mg
Malay (Latin) ms
Malayalam ml
Maltese mt
Maori mi
Marathi mr
Mongolian (Cyrillic) mn-Cyrl
Mongolian (Traditional) mn-Mong
Myanmar my
Nepali ne
Norwegian nb
Nyanja nya
Odia or
Pashto ps
Persian fa
Polish pl
Portuguese (Brazil) pt
Portuguese (Portugal) pt-pt
Punjabi pa
Queretaro Otomi otq
Romanian ro
Rundi run
Russian ru
Samoan (Latin) sm
Serbian (Cyrillic) sr-Cyrl
Serbian (Latin) sr-Latn
Sesotho st
Sesotho sa Leboa nso
Setswana tn
Sindhi sd
Sinhala si
Slovak sk
Slovenian sl
Somali (Arabic) so
Spanish es
Swahili (Latin) sw
Swedish sv
Tahitian ty
Tamil ta
Tatar (Latin) tt
Telugu te
Thai th
Tibetan bo
Tigrinya ti
Tongan to
Turkish tr
Turkmen (Latin) tk
Ukrainian uk
Upper Sorbian hsb
Urdu ur
Uyghur (Arabic) ug
Uzbek (Latin) uz
Vietnamese vi
Welsh cy
Xhosa xh
Yoruba yo
Yucatec Maya yua
Zulu zu
Негізгі бет Magical Uses of The TRANSLATE Function and DETECTLANGUAGE
Пікірлер: 75