{"id":6688,"date":"2025-01-12T16:36:34","date_gmt":"2025-01-12T16:36:34","guid":{"rendered":"https:\/\/howtogeek.blog\/lt\/?p=6688"},"modified":"2025-01-12T16:36:34","modified_gmt":"2025-01-12T16:36:34","slug":"using-excels-translate-and-detectlanguage-functions-for-enhanced-language-processing","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lt\/using-excels-translate-and-detectlanguage-functions-for-enhanced-language-processing\/","title":{"rendered":"\u201eExcel\u201c TRANSLATE ir DETECTLANGUAGE funkcij\u0173 naudojimas patobulintam kalbos apdorojimui"},"content":{"rendered":"<h3>Greitos nuorodos<\/h3>\n<p>Atraskite stebinan\u010dias \u201eMicrosoft Excel\u201c kaip vert\u0117jo galimybes! Integravus \u201eMicrosoft\u201c vertimo paslaugas, \u201eExcel\u201c ne tik suteikia galimyb\u0119 versti tekst\u0105 naudojant TRANSLATE funkcij\u0105, bet ir identifikuoti kalbas naudojant DETECTLANGUAGE funkcij\u0105.<\/p>\n<p>\u0160ios pa\u017eangiausios kalbos funkcijos buvo pristatytos 2024 m. gruod\u017eio m\u0117n. ir pasiekiamos tik staliniams kompiuteriams skirtose \u201eWindows\u201c ir \u201eMac\u201c skirtose \u201eExcel\u201c versijose, taip pat \u201eExcel\u201c, skirtose \u017einiatinkliui ir programoms mobiliesiems, jei turite \u201eMicrosoft 365\u201c prenumerat\u0105.<\/p>\n<h2 id=\"what-are-the-syntaxes\">Kas yra sintaks\u0117s?<\/h2>\n<p>Pasinerkime \u012f \u0161i\u0173 funkcij\u0173 sintakses, kad suprastume, kaip jas efektyviai panaudoti:<\/p>\n<h3 id=\"translate\">VERSTI<\/h3>\n<p>Funkcij\u0105 TRANSLATE sudaro trys argumentai:<\/p>\n<p> <code>=TRANSLATE(a,b,c)<\/code><\/p>\n<p>Pateikiame kiekvieno parametro suskirstym\u0105:<\/p>\n<ul>\n<li><strong>a<\/strong> (b\u016btina): tai gali b\u016bti tekstas, kur\u012f norite i\u0161versti (dvigubose kabut\u0117se) arba langelio nuoroda, kurioje yra tekstas.<\/li>\n<li><strong>b<\/strong> (neprivaloma): \u0161altinio kalbos kodas (dvigubose kabut\u0117se). \u012etraukus tai skatina tikslum\u0105; jei praleista, \u201eExcel\u201c bandys automati\u0161kai aptikti.<\/li>\n<li><strong>c<\/strong> (neprivaloma): tikslin\u0117s kalbos kodas (dvigubose kabut\u0117se). Jei tai nenurodyta, \u201eExcel\u201c pagal numatytuosius nustatymus pasirenka j\u016bs\u0173 sistemos kalb\u0105; visada geriau pateikti konkret\u0173 kod\u0105, kad b\u016bt\u0173 pasiekti optimal\u016bs rezultatai.<\/li>\n<\/ul>\n<p>Atminkite, kad jei pamir\u0161ite naudoti dvigubas kabutes aplink kalbos kod\u0105, \u201eExcel\u201c pateiks jums #NAME? klaida.<\/p>\n<h3 id=\"detectlanguage\">NUSTATYTI KALB\u0104<\/h3>\n<p>Prie\u0161ingai, \u0161iai funkcijai reikalingas tik vienas argumentas:<\/p>\n<p> <code>=DETECTLANGUAGE(x)<\/code><\/p>\n<p>Kur:<\/p>\n<ul>\n<li><strong>x<\/strong> : tekstas, kur\u012f norite analizuoti, \u012fterptas \u012f dvigubas kabutes arba nurodytas i\u0161 langelio.<\/li>\n<\/ul>\n<h2 id=\"language-codes\">Kalbos kodai<\/h2>\n<p>\u017demiau yra keletas da\u017eniausiai naudojam\u0173 kalb\u0173 kod\u0173. Nor\u0117dami gauti i\u0161samesn\u012f s\u0105ra\u0161\u0105, apsilankykite <a href=\"https:\/\/learn.microsoft.com\/azure\/ai-services\/Translator\/language-support\" rel=\"noopener noreferrer\" target=\"_blank\">oficialioje \u201eMicrosoft\u201c svetain\u0117je<\/a> . \u012esitikinkite, kad visi kalb\u0173 kodai formul\u0117se yra dvigubomis kabut\u0117mis:<\/p>\n<table>\n<thead>\n<tr>\n<th>Kodas<\/th>\n<th>Kalba<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>&#8220;\u012f&#8221;<\/td>\n<td>angl\u0173 kalba<\/td>\n<\/tr>\n<tr>\n<td>&#8220;yra&#8221;<\/td>\n<td>ispan\u0173<\/td>\n<\/tr>\n<tr>\n<td>&#8220;fr&#8221;<\/td>\n<td>pranc\u016bz\u0173<\/td>\n<\/tr>\n<tr>\n<td>&#8220;i\u0161&#8221;<\/td>\n<td>vokie\u010di\u0173<\/td>\n<\/tr>\n<tr>\n<td>\u201ezh-chs\u201c<\/td>\n<td>Mandarin\u0173 (supaprastinta)<\/td>\n<\/tr>\n<tr>\n<td>&#8220;ru&#8221;<\/td>\n<td>rus\u0173<\/td>\n<\/tr>\n<tr>\n<td>&#8220;su&#8221;<\/td>\n<td>arab\u0173<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"examples-of-translate-in-action\">TRANSLATE veikia pavyzd\u017eiai<\/h2>\n<p>Nor\u0117dami iliustruoti funkcij\u0105 TRANSLATE, panagrin\u0117kime du praktinius pavyzd\u017eius. Pirmasis demonstruoja nesud\u0117ting\u0105 vertimo u\u017eduot\u012f, o antrasis \u2013 dinamin\u012f vertim\u0105, naudojant i\u0161skleid\u017eiam\u0105j\u012f kalbos pasirinkimo s\u0105ra\u0161\u0105.<\/p>\n<h3 id=\"example-1-translating-text-in-cells\">1 pavyzdys: teksto vertimas langeliuose<\/h3>\n<p>\u012esivaizduokite, kad turite transporto priemon\u0117s i\u0161laid\u0173 ataskait\u0105, kuri\u0105 reikia i\u0161versti i\u0161 angl\u0173 \u012f ispan\u0173 kalb\u0105. \u0160tai kaip elgiat\u0117s:<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Transporto priemon\u0117s i\u0161laid\u0173 forma programoje \u201eExcel\u201c, paliekant tarpus kiekvieno lauko pavadinimo vertimui \u012f ispan\u0173 kalb\u0105.\" class=\"wp-image\" decoding=\"async\" height=\"463\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-vehicle-expenses-form-in-excel-with-spaces-left-for-translations-of-each-field-name-into-spanish.webp\" title=\"Transporto priemon\u0117s i\u0161laid\u0173 forma programoje \u201eExcel\u201c, paliekant tarpus kiekvieno lauko pavadinimo vertimui \u012f ispan\u0173 kalb\u0105.\" width=\"887\"\/><\/figure>\n<p>C2 langelyje \u012fveskite:<\/p>\n<p> <code>=TRANSLATE(A1,\"en\",\"es\")<\/code><\/p>\n<p>Paspaud\u0119 Enter pamatysite vertim\u0105 \u012f ispan\u0173 kalb\u0105.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Transporto priemon\u0117s i\u0161laid\u0173 forma i\u0161versta \u012f ispan\u0173 kalb\u0105 programoje \u201eExcel\u201c, naudojant TRANSLATE funkcij\u0105.\" class=\"wp-image\" decoding=\"async\" height=\"429\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/vehicle-expenses-form-translated-into-spanish-in-excel-using-the-translate-function.webp\" title=\"Transporto priemon\u0117s i\u0161laid\u0173 forma i\u0161versta \u012f ispan\u0173 kalb\u0105 programoje \u201eExcel\u201c, naudojant TRANSLATE funkcij\u0105.\" width=\"750\"\/><\/figure>\n<p>Nor\u0117dami i\u0161laikyti formatavim\u0105, naudokite formatavimo \u012frank\u012f nuo antra\u0161t\u0117s angl\u0173 kalba iki atitikmens ispan\u0173 kalba, galb\u016bt pakeiskite \u0161rift\u0105 \u012f raudon\u0105, kad b\u016bt\u0173 kontrastas.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Transporto priemon\u0117s i\u0161laid\u0173 forma i\u0161versta \u012f ispan\u0173 kalb\u0105 su pakeistu formatavimu.\" class=\"wp-image\" decoding=\"async\" height=\"143\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/vehicle-expenses-form-translated-into-spanish-in-excel-using-the-translate-function-and-the-formatting-amended-to-distinguish-the-two-languages.webp\" title=\"Transporto priemon\u0117s i\u0161laid\u0173 forma i\u0161versta \u012f ispan\u0173 kalb\u0105 su pakeistu formatavimu.\" width=\"750\"\/><\/figure>\n<p>Nukopijuokite formul\u0119 i\u0161 C1, pakoreguokite nuorod\u0105 \u012f A3 ir pritaikykite j\u0105 likusiuose langeliuose.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Funkcijos TRANSLATE taikymas keliems Excel langeliams.\" class=\"wp-image\" decoding=\"async\" height=\"204\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-information-field-titles-that-are-translated-from-english-to-spanish-using-the-translate-function.webp\" title=\"Funkcijos TRANSLATE taikymas keliems Excel langeliams.\" width=\"892\"\/><\/figure>\n<p>\u0160is metodas u\u017etikrina, kad kiekvienas pavadinimas b\u016bt\u0173 tinkamai i\u0161verstas ir ai\u0161kiai suformatuotas, kad naudotojas b\u016bt\u0173 ai\u0161kus.<\/p>\n<h3 id=\"example-2-selecting-a-translating-language-from-a-drop-down-list\">2 pavyzdys: vertimo kalbos pasirinkimas i\u0161 i\u0161skleid\u017eiamojo s\u0105ra\u0161o<\/h3>\n<p>Tada sukurkime interaktyvi\u0105 apklaus\u0105, kuri leis respondentams i\u0161skleid\u017eiamajame s\u0105ra\u0161e pasirinkti pageidaujam\u0105 kalb\u0105.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eMicrosoft Excel\u201c apklausa su skirtomis erdv\u0117mis klausim\u0173 vertimams.\" class=\"wp-image\" decoding=\"async\" height=\"427\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-survey-in-microsoft-excel-with-spaces-where-translations-of-the-questions-will-appear.webp\" title=\"\u201eMicrosoft Excel\u201c apklausa su skirtomis erdv\u0117mis klausim\u0173 vertimams.\" width=\"717\"\/><\/figure>\n<p>Pirmiausia 2 lape sukurkite parink\u010di\u0173 s\u0105ra\u0161\u0105 (pvz., ispan\u0173, pranc\u016bz\u0173, arab\u0173) ir atitinkamus j\u0173 kodus gretimuose langeliuose.<\/p>\n<p>1 lapo langelyje C1 \u012fveskite:<\/p>\n<p> <code>=TRANSLATE(A1,\"en\",B1)<\/code><\/p>\n<p>Paspauskite Enter, tada naudokite likusi\u0173 eilu\u010di\u0173 u\u017epildymo ranken\u0117l\u0119, kad vertimai b\u016bt\u0173 generuojami automati\u0161kai.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c lape yra kalbos vertimai, sugeneruoti naudojant funkcij\u0105 TRANSLATE.\" class=\"wp-image\" decoding=\"async\" height=\"247\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-the-names-of-three-languages-in-english-their-language-codes-and-their-translations-into-their-respective-languages-1.webp\" title=\"\u201eExcel\u201c lape yra kalbos vertimai, sugeneruoti naudojant funkcij\u0105 TRANSLATE.\" width=\"750\"\/><\/figure>\n<p>Tada sukurkite i\u0161skleid\u017eiam\u0105j\u012f s\u0105ra\u0161\u0105 savo apklausai skirtame langelyje, skirtuke Duomenys eidami \u012f \u201eDuomen\u0173 patvirtinimas\u201c. U\u017epildykite j\u012f savo kalb\u0173 s\u0105ra\u0161ais i\u0161 2 lapo.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c i\u0161skleid\u017eiamojo s\u0105ra\u0161o duomen\u0173 patvirtinimo nustatymas.\" class=\"wp-image\" decoding=\"async\" height=\"472\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-data-validation-window-in-excel-with-list-selected-in-the-allow-field-and-cells-c1-to-c3-in-sheet-2-selected-in-the-source-field.webp\" title=\"\u201eExcel\u201c i\u0161skleid\u017eiamojo s\u0105ra\u0161o duomen\u0173 patvirtinimo nustatymas.\" width=\"750\"\/><\/figure>\n<p>Naujai sukurtame i\u0161skleid\u017eiamajame meniu pasirinkite kalb\u0105; dabar esame pasiruo\u0161\u0119 skland\u017eiai i\u0161versti j\u016bs\u0173 klausimus \u012f pasirinkt\u0105 kalb\u0105:<\/p>\n<p> <code>=TRANSLATE(A3,\"en\",XLOOKUP($B$1,Sheet2!$C$1:$C$3,Sheet2!$B$1:$B$3))<\/code><\/p>\n<p>U\u017efiksuokite langeli\u0173 pozicijas dolerio \u017eenklais, kad formul\u0117 i\u0161likt\u0173 nepakitusi u\u017epild\u017eius likusius klausimus.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Apklausos klausimai i\u0161versti pagal pasirinkt\u0105 kalb\u0105.\" class=\"wp-image\" decoding=\"async\" height=\"402\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-list-of-questions-in-a-survey-in-excel-translated-to-a-language-selected-from-a-drop-down-list-in-cell-b2.webp\" title=\"Apklausos klausimai i\u0161versti pagal pasirinkt\u0105 kalb\u0105.\" width=\"750\"\/><\/figure>\n<p>Prireikus pakoreguokite formatavim\u0105 ir steb\u0117kite, kaip j\u016bs\u0173 klausimai prisitaiko prie kalbos pasirinkimo i\u0161skleid\u017eiamajame meniu.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Apklausos klausimai i\u0161versti \u012f arab\u0173 kalb\u0105, remiantis i\u0161skleid\u017eiamuoju kalbos pasirinkimu.\" class=\"wp-image\" decoding=\"async\" height=\"421\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-list-of-questions-in-a-survey-in-excel-translated-to-arabic.webp\" title=\"Apklausos klausimai i\u0161versti \u012f arab\u0173 kalb\u0105, remiantis i\u0161skleid\u017eiamuoju kalbos pasirinkimu.\" width=\"750\"\/><\/figure>\n<h2 id=\"an-example-of-detectlanguage-in-action\">DETECTLANGUAGE veikimo pavyzdys<\/h2>\n<p>Daugiakalbiams duomen\u0173 rinkiniams funkcija DETECTLANGUAGE tampa ne\u012fkainojama. Tarkime, kad A1\u2013A3 langeliuose susiduriate su trimis sakiniais skirtingomis kalbomis:<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c lapas, kuriame yra trys sakiniai u\u017esienio kalba langeliuose A1\u2013A3.\" class=\"wp-image\" decoding=\"async\" height=\"225\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-three-foreign-language-sentences-in-cells-a1-to-a3.webp\" title=\"\u201eExcel\u201c lapas, kuriame yra trys sakiniai u\u017esienio kalba langeliuose A1\u2013A3.\" width=\"750\"\/><\/figure>\n<p>Langelyje B1 \u012fveskite formul\u0119:<\/p>\n<p> <code>=DETECTLANGUAGE(A1)<\/code><\/p>\n<p>Naudojant u\u017epildymo ranken\u0117l\u0119, \u0161i formul\u0117 bus nukopijuota per B2 ir B3, parodydami kiekvienos fraz\u0117s atitinkamus kalbos kodus.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Excel lapas, identifikuojantis u\u017esienio sakini\u0173 kalbas naudojant DETECTLANGUAGE funkcij\u0105.\" class=\"wp-image\" decoding=\"async\" height=\"247\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-the-names-of-three-languages-in-english-their-language-codes-and-their-translations-into-their-respective-languages-2.webp\" title=\"Excel lapas, identifikuojantis u\u017esienio sakini\u0173 kalbas naudojant DETECTLANGUAGE funkcij\u0105.\" width=\"750\"\/><\/figure>\n<p>Nor\u0117dami gauti papildom\u0173 \u012f\u017evalg\u0173 apie kalb\u0173 kodus, \u017er. <a href=\"https:\/\/learn.microsoft.com\/azure\/ai-services\/Translator\/language-support\" rel=\"noopener noreferrer\" target=\"_blank\">\u201eMicrosoft\u201c vert\u0117jo kalbos palaikymo puslap\u012f<\/a> .<\/p>\n<p>Be to, programoje \u201eMicrosoft Word\u201c yra \u012fvairi\u0173 vertimo funkcij\u0173, leid\u017eian\u010di\u0173 vartotojams pary\u0161kinti ver\u010diam\u0105 tekst\u0105 arba pana\u0161iai i\u0161versti visus dokumentus.<\/p>\n<h3>Papildomos \u012f\u017evalgos<\/h3>\n<h4><strong>1. Ar galiu naudoti TRANSLATE funkcij\u0105 bet kokiai kalb\u0173 poravimui?<\/strong><\/h4>\n<p>Taip, jei kalbas palaiko \u201eMicrosoft\u201c vertimo paslaugos. Galimas parinktis rasite pateiktame kalb\u0173 kod\u0173 s\u0105ra\u0161e.<\/p>\n<h4><strong>2. Kaip veikia funkcija DETECTLANGUAGE?<\/strong><\/h4>\n<p>Funkcija DETECTLANGUAGE nuskaito pateikt\u0105 tekst\u0105 ir gr\u0105\u017eina aptiktos kalbos kod\u0105. Tai ypa\u010d naudinga tvarkant duomen\u0173 rinkinius, kuriuose yra kelios kalbos.<\/p>\n<h4><strong>3. Ar \u012f funkcij\u0105 TRANSLATE b\u016btina \u012ftraukti \u0161altinio ir tikslin\u0117s kalbos kodus?<\/strong><\/h4>\n<p>Nors \u0161ie kodai n\u0117ra privalomi, jie paprastai pateikia tikslesnius vertimus, nei pasikliaujant vien automatiniu aptikimu.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/www.howtogeek.com\/how-to-use-the-translate-function-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\u0160altinis ir vaizdai<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Greitos nuorodos Atraskite stebinan\u010dias \u201eMicrosoft Excel\u201c kaip vert\u0117jo galimybes! Integravus \u201eMicrosoft\u201c vertimo paslaugas, \u201eExcel\u201c ne tik suteikia galimyb\u0119 versti tekst\u0105 naudojant TRANSLATE funkcij\u0105, bet ir identifikuoti kalbas naudojant DETECTLANGUAGE funkcij\u0105. \u0160ios pa\u017eangiausios kalbos funkcijos buvo pristatytos 2024 m. gruod\u017eio m\u0117n. ir pasiekiamos tik staliniams kompiuteriams skirtose \u201eWindows\u201c ir \u201eMac\u201c skirtose \u201eExcel\u201c versijose, taip pat \u201eExcel\u201c, [&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":[123,867,282,9],"class_list":["post-6688","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-365","tag-microsoft-excel","tag-windows"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/6688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/comments?post=6688"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/6688\/revisions"}],"predecessor-version":[{"id":6689,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/6688\/revisions\/6689"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/media?parent=6688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/categories?post=6688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/tags?post=6688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}