{"id":7565,"date":"2025-01-21T11:20:36","date_gmt":"2025-01-21T11:20:36","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=7565"},"modified":"2025-01-21T11:20:36","modified_gmt":"2025-01-21T11:20:36","slug":"using-translate-and-detectlanguage-functions-in-excel-a-complete-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/using-translate-and-detectlanguage-functions-in-excel-a-complete-guide\/","title":{"rendered":"Pou\u017eit\u00ed funkc\u00ed TRANSLATE a DETECTLANGUAGE v Excelu: Kompletn\u00ed pr\u016fvodce"},"content":{"rendered":"<p>Microsoft Excel je \u0161iroce uzn\u00e1v\u00e1n jako v\u00fdkonn\u00fd n\u00e1stroj pro spr\u00e1vu a anal\u00fdzu dat, ale mnoho u\u017eivatel\u016f si neuv\u011bdomuje jeho schopnosti p\u0159ekl\u00e1dat jazyky a detekovat jazyk pou\u017e\u00edvan\u00fd v se\u0161itu. Vyu\u017eit\u00ed nov\u00fdch funkc\u00ed TRANSLATE a DETECTLANGUAGE m\u016f\u017ee v\u00fdrazn\u011b zlep\u0161it va\u0161e zku\u0161enosti se spr\u00e1vou dat.<\/p>\n<p>Tyto funkce byly spu\u0161t\u011bny v prosinci 2024 a jsou dostupn\u00e9 v r\u016fzn\u00fdch verz\u00edch Excelu, v\u010detn\u011b desktopov\u00e9 (Windows a Mac), mobiln\u00ed aplikace (pro p\u0159edplatitele Microsoft 365) a webov\u00e9 verze. Poj\u010fme se pono\u0159it do toho, jak efektivn\u011b vyu\u017e\u00edt s\u00edlu t\u011bchto funkc\u00ed.<\/p>\n<h2 id=\"syntax-of-the-translate-function\">Pochopen\u00ed syntaxe funkce TRANSLATE<\/h2>\n<p>Syntaxe funkce TRANSLATE je jednoduch\u00e1. Vy\u017eaduje to t\u0159i n\u00e1sleduj\u00edc\u00ed argumenty:<\/p>\n<p> <code>=TRANSLATE(a, b, c)<\/code><\/p>\n<ul>\n<li> <code>a<\/code>: Text, kter\u00fd chcete p\u0159elo\u017eit, uzav\u0159en\u00fd v uvozovk\u00e1ch nebo jako odkaz na bu\u0148ku obsahuj\u00edc\u00ed text.<\/li>\n<li> <code>b<\/code>: K\u00f3d zdrojov\u00e9ho jazyka (nap\u0159. \u201ees\u201c pro \u0161pan\u011bl\u0161tinu). Tento argument je voliteln\u00fd; pokud je vynech\u00e1n, Excel se pokus\u00ed automaticky detekovat zdrojov\u00fd jazyk. Poskytnut\u00ed tohoto k\u00f3du v\u0161ak m\u016f\u017ee zv\u00fd\u0161it p\u0159esnost p\u0159ekladu.<\/li>\n<li> <code>c<\/code>: K\u00f3d c\u00edlov\u00e9ho jazyka tak\u00e9 ve dvojit\u00fdch uvozovk\u00e1ch. Pokud nen\u00ed zad\u00e1no, Excel pou\u017eije v\u00fdchoz\u00ed jazyk va\u0161eho syst\u00e9mu.<\/li>\n<\/ul>\n<h2 id=\"syntax-of-the-detectlanguage-function\">Prozkoum\u00e1n\u00ed syntaxe funkce DETECTLANGUAGE<\/h2>\n<p>Funkce DETECTLANGUAGE je jednodu\u0161\u0161\u00ed a obsahuje pouze jeden argument:<\/p>\n<p> <code>=DETECTLANGUAGE(x)<\/code><\/p>\n<ul>\n<li> <code>x<\/code>: Text, kter\u00fd m\u00e1 b\u00fdt analyzov\u00e1n, bu\u010f ve dvojit\u00fdch uvozovk\u00e1ch, nebo odkaz na bu\u0148ku obsahuj\u00edc\u00ed text nezbytn\u00fd pro detekci jazyka.<\/li>\n<\/ul>\n<p>Pro vyu\u017eit\u00ed t\u011bchto funkc\u00ed je nezbytn\u00e1 znalost jazykov\u00fdch k\u00f3d\u016f. Nap\u0159\u00edklad \u201een\u201c ozna\u010duje angli\u010dtinu, \u201eru\u201c pro ru\u0161tinu, \u201ees\u201c pro \u0161pan\u011bl\u0161tinu a \u201efr\u201c pro francouz\u0161tinu. \u00dapln\u00fd seznam k\u00f3d\u016f jazyk\u016f lze z\u00edskat prost\u0159ednictv\u00edm ofici\u00e1ln\u00edch zdroj\u016f spole\u010dnosti Microsoft.<\/p>\n<h2 id=\"using-the-translate-function\">Jak pou\u017e\u00edvat funkci TRANSLATE<\/h2>\n<ul>\n<li>Za\u010dn\u011bte otev\u0159en\u00edm nov\u00e9ho listu aplikace Excel a vlo\u017een\u00edm textu, kter\u00fd chcete p\u0159elo\u017eit, do libovoln\u00e9 bu\u0148ky. Zadejte sv\u016fj text nap\u0159\u00edklad do bu\u0148ky A2.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159\u00edklad textu k p\u0159ekladu v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-310-1.webp\" title=\"P\u0159\u00edklad textu k p\u0159ekladu v Excelu\" width=\"831\"\/><\/figure>\n<ul>\n<li>Vyberte jinou bu\u0148ku pro zobrazen\u00ed p\u0159ekladu a zadejte <code>=TRANSLATE(<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vstup do funkce TRANSLATE\" class=\"wp-image\" decoding=\"async\" height=\"434\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-311-1.webp\" title=\"Vstup do funkce TRANSLATE\" width=\"771\"\/><\/figure>\n<ul>\n<li>Uve\u010fte text v bu\u0148ce A2, za kterou n\u00e1sleduje \u010d\u00e1rka a ur\u010dete k\u00f3d zdrojov\u00e9ho jazyka, um\u00edst\u011bte jej do dvojit\u00fdch uvozovek (nap\u0159. <code>\"es\"<\/code>).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vstup pro k\u00f3d zdrojov\u00e9ho jazyka\" class=\"wp-image\" decoding=\"async\" height=\"456\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-312-1.webp\" title=\"Vstup pro k\u00f3d zdrojov\u00e9ho jazyka\" width=\"810\"\/><\/figure>\n<ul>\n<li><code>\"en\"<\/code>P\u0159idejte dal\u0161\u00ed \u010d\u00e1rku a p\u0159ed uzav\u0159en\u00edm z\u00e1vorky zadejte k\u00f3d c\u00edlov\u00e9ho jazyka ve dvojit\u00fdch uvozovk\u00e1ch (nap\u0159. pro angli\u010dtinu).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Dokon\u010den\u00ed funkce TRANSLATE\" class=\"wp-image\" decoding=\"async\" height=\"448\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-313-1.webp\" title=\"Dokon\u010den\u00ed funkce TRANSLATE\" width=\"797\"\/><\/figure>\n<ul>\n<li>Stiskn\u011bte Enter a Excel zobraz\u00ed p\u0159elo\u017een\u00fd text ve vybran\u00e9 bu\u0148ce.<\/li>\n<\/ul>\n<h2 id=\"using-the-detectlanguage-function\">Vyu\u017eit\u00ed funkce DETECTLANGUAGE<\/h2>\n<p>Funkce DETECTLANGUAGE je neoceniteln\u00e1 pro identifikaci jazyka dan\u00e9ho textu, co\u017e usnad\u0148uje p\u0159\u00edstup k p\u0159eklad\u016fm.<\/p>\n<ul>\n<li>Za\u010dn\u011bte otev\u0159en\u00edm nov\u00e9ho listu aplikace Excel a vlo\u017een\u00edm textu, jeho\u017e jazyk chcete identifikovat.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vlo\u017een\u00edm textu zjist\u011bte jazyk v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-310-1-1.webp\" title=\"Vlo\u017een\u00edm textu zjist\u011bte jazyk v Excelu\" width=\"831\"\/><\/figure>\n<ul>\n<li>V jin\u00e9 bu\u0148ce zadejte <code>=DETECTLANGUAGE(<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vstup do funkce DETECTLANGUAGE\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-314-1.webp\" title=\"Vstup do funkce DETECTLANGUAGE\" width=\"881\"\/><\/figure>\n<ul>\n<li>P\u0159idejte odkaz na bu\u0148ku obsahuj\u00edc\u00ed text, kter\u00fd m\u00e1 b\u00fdt analyzov\u00e1n.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vyberte odkaz na bu\u0148ku pro detekci jazyka\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-315-1.webp\" title=\"Vyberte odkaz na bu\u0148ku pro detekci jazyka\" width=\"852\"\/><\/figure>\n<ul>\n<li>Kdy\u017e stisknete Enter, Excel v\u00e1m poskytne k\u00f3d jazyka detekovan\u00e9ho textu, co\u017e znamen\u00e1 n\u011bco jako \u201ees\u201c pro \u0161pan\u011bl\u0161tinu.<\/li>\n<\/ul>\n<h2 id=\"make-translations-dynamic\">Vylep\u0161en\u00ed p\u0159eklad\u016f pomoc\u00ed dynamick\u00fdch mo\u017enost\u00ed<\/h2>\n<p>Dynamick\u00e9 p\u0159eklady vylep\u0161uj\u00ed pr\u00e1ci s Excelem a umo\u017e\u0148uj\u00ed zv\u00fd\u0161enou interaktivitu s r\u016fzn\u00fdmi jazyky.<\/p>\n<ul>\n<li>Za\u010dn\u011bte vytvo\u0159en\u00edm seznamu preferovan\u00fdch jazyk\u016f na nov\u00e9m listu aplikace Excel. Kliknut\u00edm na tla\u010d\u00edtko \u201e+\u201c otev\u0159ete nov\u00fd list.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytvo\u0159en\u00ed nov\u00e9ho listu pro jazyky\" class=\"wp-image\" decoding=\"async\" height=\"475\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-319-1.webp\" title=\"Vytvo\u0159en\u00ed nov\u00e9ho listu pro jazyky\" width=\"844\"\/><\/figure>\n<ul>\n<li>Na tomto nov\u00e9m listu zadejte n\u00e1zvy jazyk\u016f do sloupce A a jejich odpov\u00eddaj\u00edc\u00ed k\u00f3dy do sloupce B.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Zad\u00e1n\u00ed k\u00f3d\u016f jazyk\u016f v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"523\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-320-1.webp\" title=\"Zad\u00e1n\u00ed k\u00f3d\u016f jazyk\u016f v Excelu\" width=\"930\"\/><\/figure>\n<ul>\n<li>Do bu\u0148ky C1 zadejte <code>=TRANSLATE(A1,\"en\",B1)<\/code>a stiskn\u011bte Enter. P\u0159eta\u017een\u00edm \u00fachytu v\u00fdpln\u011b dol\u016f se automaticky vygeneruj\u00ed p\u0159eklady pro zb\u00fdvaj\u00edc\u00ed \u0159\u00e1dky.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vypln\u011bn\u00ed funkce p\u0159ekladu\" class=\"wp-image\" decoding=\"async\" height=\"497\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-321-1.webp\" title=\"Vypln\u011bn\u00ed funkce p\u0159ekladu\" width=\"883\"\/><\/figure>\n<ul>\n<li>Vra\u0165te se na sv\u016fj p\u016fvodn\u00ed list kliknut\u00edm na n\u011bj vlevo dole. Vyberte, kam chcete p\u0159idat rozev\u00edrac\u00ed seznam pro v\u00fdb\u011br jazyka, pot\u00e9 p\u0159ejd\u011bte na kartu \u201eData\u201c a klikn\u011bte na \u201eOv\u011b\u0159en\u00ed dat\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159\u00edstup k ov\u011b\u0159en\u00ed dat v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"503\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-316-1.webp\" title=\"P\u0159\u00edstup k ov\u011b\u0159en\u00ed dat v Excelu\" width=\"894\"\/><\/figure>\n<ul>\n<li>V dialogov\u00e9m okn\u011b Ov\u011b\u0159en\u00ed dat vyberte na kart\u011b Nastaven\u00ed polo\u017eku Seznam.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Nastaven\u00ed ov\u011b\u0159en\u00ed dat\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-317-1.webp\" title=\"Nastaven\u00ed ov\u011b\u0159en\u00ed dat\" width=\"852\"\/><\/figure>\n<ul>\n<li>V poli Zdroj zv\u00fdrazn\u011bte bu\u0148ky z Listu 2 obsahuj\u00edc\u00ed va\u0161e jazykov\u00e9 mo\u017enosti a stiskn\u011bte Enter. T\u00edm se vytvo\u0159\u00ed rozev\u00edrac\u00ed seznam s jazyky, kter\u00e9 jste d\u0159\u00edve p\u0159idali.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Rozbalovac\u00ed seznam s jazykov\u00fdmi mo\u017enostmi\" class=\"wp-image\" decoding=\"async\" height=\"482\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-322-1.webp\" title=\"Rozbalovac\u00ed seznam s jazykov\u00fdmi mo\u017enostmi\" width=\"857\"\/><\/figure>\n<ul>\n<li>Vyu\u017eit\u00edm zad\u00e1v\u00e1n\u00ed dat propojte funkci P\u0158EKLAD s rozev\u00edrac\u00edm seznamem pomoc\u00ed: <code>=TRANSLATE(A3,\"en\",XLOOKUP($B$1,Sheet2!$C$1:$C$3,Sheet2!$B$1:$B$3))<\/code>.<\/li>\n<\/ul>\n<h3 id=\"things-to-know\">D\u016fle\u017eit\u00e9 \u00favahy<\/h3>\n<ul>\n<li>M\u011bjte na pam\u011bti, \u017ee funkce TRANSLATE a DETECTLANGUAGE nemus\u00ed b\u00fdt aktu\u00e1ln\u011b dostupn\u00e9 ve v\u0161ech verz\u00edch Excelu kv\u016fli jejich ned\u00e1vn\u00e9mu zaveden\u00ed.<\/li>\n<li>Chcete-li po p\u0159ekladu zachovat jednotn\u00fd vzhled, zva\u017ete \u00fapravu velikost\u00ed a styl\u016f p\u00edsma tak, aby vyhovovaly r\u016fzn\u00fdm d\u00e9lk\u00e1m p\u0159elo\u017een\u00e9ho textu.<\/li>\n<li>Pokud naraz\u00edte na chybu \u201eP\u0159\u00edli\u0161 dlouh\u00fd text\u201c, zkuste zmen\u0161it bu\u010f mno\u017estv\u00ed textu v bu\u0148ce, nebo jej\u00ed velikost, zat\u00edmco \u201eChyba v hodnot\u011b\u201c ozna\u010duje p\u0159\u00edtomnost netextov\u00e9ho prvku, kter\u00fd by m\u011bl b\u00fdt odstran\u011bn. Chyba \u201eNeplatn\u00fd jazyk\u201c obvykle vznik\u00e1 z nespr\u00e1vn\u00fdch k\u00f3d\u016f jazyk\u016f.<\/li>\n<li>Ob\u011b funkce vy\u017eaduj\u00ed aktivn\u00ed p\u0159ipojen\u00ed k internetu pro p\u0159\u00edstup k p\u0159ekladatelsk\u00fdm slu\u017eb\u00e1m spole\u010dnosti Microsoft a u\u017eivatel\u00e9 by m\u011bli m\u00edt na pam\u011bti sv\u00e9 denn\u00ed limity vyu\u017eit\u00ed, aby se vyhnuli omezen\u00ed.<\/li>\n<\/ul>\n<h2>\u010casto kladen\u00e9 ot\u00e1zky<\/h2>\n<h3><strong>1. Jak mohu zkontrolovat, zda moje verze aplikace Excel podporuje funkce TRANSLATE a DETECTLANGUAGE?<\/strong><\/h3>\n<p>Dostupnost t\u011bchto funkc\u00ed z\u00e1vis\u00ed na verzi Excelu, kterou pou\u017e\u00edv\u00e1te. Vyhledejte aktualizace nebo se pod\u00edvejte na ofici\u00e1ln\u00ed str\u00e1nku podpory spole\u010dnosti Microsoft a ov\u011b\u0159te, zda byly implementov\u00e1ny ve va\u0161\u00ed verzi.<\/p>\n<h3><strong>2. Co m\u00e1m d\u011blat, pokud naraz\u00edm na chybu \u201eNeplatn\u00fd jazyk\u201c?<\/strong><\/h3>\n<p>Ujist\u011bte se, \u017ee ve vzorci pou\u017e\u00edv\u00e1te spr\u00e1vn\u00fd k\u00f3d jazyka. Je nezbytn\u00e9 odk\u00e1zat na aktu\u00e1ln\u00ed zdroj jazykov\u00fdch k\u00f3d\u016f, proto\u017ee k tomuto probl\u00e9mu mohou v\u00e9st i drobn\u00e9 chyby.<\/p>\n<h3><strong>3. Mohu tyto funkce pou\u017e\u00edvat offline?<\/strong><\/h3>\n<p>Bohu\u017eel funkce TRANSLATE a DETECTLANGUAGE vy\u017eaduj\u00ed aktivn\u00ed p\u0159ipojen\u00ed k internetu, proto\u017ee p\u0159i pln\u011bn\u00ed sv\u00fdch \u00fakol\u016f spol\u00e9haj\u00ed na online p\u0159ekladatelsk\u00e9 slu\u017eby spole\u010dnosti Microsoft.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-translate-and-detectlanguage-functions-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Zdroj a obr\u00e1zky<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel je \u0161iroce uzn\u00e1v\u00e1n jako v\u00fdkonn\u00fd n\u00e1stroj pro spr\u00e1vu a anal\u00fdzu dat, ale mnoho u\u017eivatel\u016f si neuv\u011bdomuje jeho schopnosti p\u0159ekl\u00e1dat jazyky a detekovat jazyk pou\u017e\u00edvan\u00fd v se\u0161itu. Vyu\u017eit\u00ed nov\u00fdch funkc\u00ed TRANSLATE a DETECTLANGUAGE m\u016f\u017ee v\u00fdrazn\u011b zlep\u0161it va\u0161e zku\u0161enosti se spr\u00e1vou dat. Tyto funkce byly spu\u0161t\u011bny v prosinci 2024 a jsou dostupn\u00e9 v r\u016fzn\u00fdch verz\u00edch [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[126,283],"class_list":["post-7565","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/7565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/comments?post=7565"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/7565\/revisions"}],"predecessor-version":[{"id":7566,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/7565\/revisions\/7566"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=7565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=7565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=7565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}