{"id":7387,"date":"2025-01-21T11:22:08","date_gmt":"2025-01-21T11:22:08","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=7387"},"modified":"2025-01-21T11:22:08","modified_gmt":"2025-01-21T11:22:08","slug":"using-translate-and-detectlanguage-functions-in-excel-a-complete-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/using-translate-and-detectlanguage-functions-in-excel-a-complete-guide\/","title":{"rendered":"Funkciju TRANSLATE un DETECTLANGUAGE izmanto\u0161ana programm\u0101 Excel: piln\u012bga rokasgr\u0101mata"},"content":{"rendered":"<p>Programma Microsoft Excel ir pla\u0161i atz\u012bta par jaud\u012bgu datu p\u0101rvald\u012bbas un anal\u012bzes r\u012bku, tom\u0113r daudzi lietot\u0101ji neapzin\u0101s t\u0101s iesp\u0113jas tulkot valodas un noteikt darbgr\u0101mat\u0101 izmantoto valodu. Jauno funkciju TRANSLATE un DETECTLANGUAGE izmanto\u0161ana var iev\u0113rojami uzlabot j\u016bsu datu p\u0101rvald\u012bbas pieredzi.<\/p>\n<p>\u0160\u012bs funkcijas tika palaistas 2024.\u00a0gada decembr\u012b, un t\u0101s ir pieejamas da\u017e\u0101d\u0101s Excel versij\u0101s, tostarp darbvirsm\u0101 (Windows un Mac), mobilaj\u0101 lietotn\u0113 (Microsoft\u00a0365 abonentiem) un t\u012bmek\u013ca versij\u0101. Apskat\u012bsim, k\u0101 efekt\u012bvi izmantot \u0161o funkciju jaudu.<\/p>\n<h2 id=\"syntax-of-the-translate-function\">Funkcijas TRANSLATE sintakse izpratne<\/h2>\n<p>Funkcijas TRANSLATE sintakse ir vienk\u0101r\u0161a. Tam nepiecie\u0161ami tr\u012bs \u0161\u0101di argumenti:<\/p>\n<p> <code>=TRANSLATE(a, b, c)<\/code><\/p>\n<ul>\n<li> <code>a<\/code>: teksts, ko v\u0113laties tulkot, ievietots dubultp\u0113di\u0146\u0101s vai k\u0101 \u0161\u016bnas atsauce, kur\u0101 ir teksts.<\/li>\n<li> <code>b<\/code>: avota valodas kods (piem., \u201ces\u201d sp\u0101\u0146u valod\u0101). \u0160is arguments nav oblig\u0101ts; ja tas tiek izlaists, programma Excel m\u0113\u0123in\u0101s autom\u0101tiski noteikt avota valodu. Tom\u0113r \u0161\u012b koda nodro\u0161in\u0101\u0161ana var uzlabot tulko\u0161anas precizit\u0101ti.<\/li>\n<li> <code>c<\/code>: M\u0113r\u0137valodas kods ar\u012b dubultp\u0113di\u0146\u0101s. Ja tas nav nor\u0101d\u012bts, programma Excel p\u0113c noklus\u0113juma izmanto j\u016bsu sist\u0113mas valodu.<\/li>\n<\/ul>\n<h2 id=\"syntax-of-the-detectlanguage-function\">Funkcijas DETECTLANGUAGE sintakse izp\u0113te<\/h2>\n<p>Funkcija DETECTLANGUAGE ir vienk\u0101r\u0161\u0101ka, un taj\u0101 ir tikai viens arguments:<\/p>\n<p> <code>=DETECTLANGUAGE(x)<\/code><\/p>\n<ul>\n<li> <code>x<\/code>: analiz\u0113jamais teksts vai nu dubultp\u0113di\u0146\u0101s, vai atsauce uz \u0161\u016bnu, kur\u0101 ir valodas noteik\u0161anai nepiecie\u0161amais teksts.<\/li>\n<\/ul>\n<p>Lai izmantotu \u0161\u012bs funkcijas, ir \u013coti svar\u012bgi zin\u0101t valodu kodus. Piem\u0113ram, \u201cen\u201d attiecas uz ang\u013cu valodu, \u201cru\u201d uz krievu valodu, \u201ces\u201d uz sp\u0101\u0146u valodu un \u201cfr\u201d uz fran\u010du valodu. Visaptvero\u0161am valodu kodu sarakstam var piek\u013c\u016bt, izmantojot Microsoft ofici\u0101los resursus.<\/p>\n<h2 id=\"using-the-translate-function\">K\u0101 izmantot funkciju TRANSLATE<\/h2>\n<ul>\n<li>S\u0101ciet, atverot jaunu Excel darblapu un iel\u012bm\u0113jot tekstu, kuru v\u0113laties tulkot, jebkur\u0101 \u0161\u016bn\u0101. Piem\u0113ram, ievadiet tekstu \u0161\u016bn\u0101 A2.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Teksta piem\u0113rs tulko\u0161anai programm\u0101 Excel\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-310-1.webp\" title=\"Teksta piem\u0113rs tulko\u0161anai programm\u0101 Excel\" width=\"831\"\/><\/figure>\n<ul>\n<li>Atlasiet citu \u0161\u016bnu, lai par\u0101d\u012btu tulkojumu, un ierakstiet <code>=TRANSLATE(<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Funkcijas TRANSLATE ievad\u012b\u0161ana\" class=\"wp-image\" decoding=\"async\" height=\"434\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-311-1.webp\" title=\"Funkcijas TRANSLATE ievad\u012b\u0161ana\" width=\"771\"\/><\/figure>\n<ul>\n<li>Tekstam izmantojiet atsauces \u0161\u016bnu A2, kam seko komats, un nor\u0101diet avota valodas kodu, ievietojot to dubultp\u0113di\u0146\u0101s (piem\u0113ram, <code>\"es\"<\/code>).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Ievade avota valodas kodam\" class=\"wp-image\" decoding=\"async\" height=\"456\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-312-1.webp\" title=\"Ievade avota valodas kodam\" width=\"810\"\/><\/figure>\n<ul>\n<li>Pievienojiet v\u0113l vienu komatu, p\u0113c tam nor\u0101diet m\u0113r\u0137a valodas kodu dubultp\u0113di\u0146\u0101s (piem., <code>\"en\"<\/code>ang\u013cu valod\u0101), pirms aizverat iekava.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Funkcijas TRANSLATE pabeig\u0161ana\" class=\"wp-image\" decoding=\"async\" height=\"448\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-313-1.webp\" title=\"Funkcijas TRANSLATE pabeig\u0161ana\" width=\"797\"\/><\/figure>\n<ul>\n<li>Nospiediet Enter, un programma Excel par\u0101d\u012bs tulkoto tekstu atlas\u012btaj\u0101 \u0161\u016bn\u0101.<\/li>\n<\/ul>\n<h2 id=\"using-the-detectlanguage-function\">Funkcijas DETECTLANGUAGE izmanto\u0161ana<\/h2>\n<p>Funkcija DETECTLANGUAGE ir nenov\u0113rt\u0113jama, lai identific\u0113tu dot\u0101 teksta valodu, t\u0101d\u0113j\u0101di atvieglojot pieeju tulkojumiem.<\/p>\n<ul>\n<li>S\u0101ciet, atverot jaunu Excel darblapu un iel\u012bm\u0113jot tekstu, kura valodu v\u0113laties identific\u0113t.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Iel\u012bm\u0113jiet tekstu, lai programm\u0101 Excel noteiktu valodu\" 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=\"Iel\u012bm\u0113jiet tekstu, lai programm\u0101 Excel noteiktu valodu\" width=\"831\"\/><\/figure>\n<ul>\n<li>Cit\u0101 \u0161\u016bn\u0101 ievadiet <code>=DETECTLANGUAGE(<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Funkcijas DETECTLANGUAGE ievad\u012b\u0161ana\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-314-1.webp\" title=\"Funkcijas DETECTLANGUAGE ievad\u012b\u0161ana\" width=\"881\"\/><\/figure>\n<ul>\n<li>Pievienojiet \u0161\u016bnas atsauci, kur\u0101 ir analiz\u0113jamais teksts.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Atlasiet \u0161\u016bnas atsauci valodas noteik\u0161anai\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-315-1.webp\" title=\"Atlasiet \u0161\u016bnas atsauci valodas noteik\u0161anai\" width=\"852\"\/><\/figure>\n<ul>\n<li>Nospie\u017eot tausti\u0146u Enter, programma Excel sniegs jums atkl\u0101t\u0101 teksta valodas kodu, sp\u0101\u0146u valod\u0101 nor\u0101dot kaut ko l\u012bdz\u012bgu \u201ces\u201d.<\/li>\n<\/ul>\n<h2 id=\"make-translations-dynamic\">Tulkojumu uzlabo\u0161ana, izmantojot dinamisk\u0101s opcijas<\/h2>\n<p>Dinamiskie tulkojumi uzlabo j\u016bsu Excel lieto\u0161anas pieredzi, \u013caujot palielin\u0101t interaktivit\u0101ti ar da\u017e\u0101d\u0101m valod\u0101m.<\/p>\n<ul>\n<li>S\u0101ciet, izveidojot v\u0113lamo valodu sarakstu jaun\u0101 Excel lap\u0101. Noklik\u0161\u0137iniet uz pogas &#8220;+&#8221;, lai atv\u0113rtu jaunu lapu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Jaunas lapas izveide valod\u0101m\" class=\"wp-image\" decoding=\"async\" height=\"475\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-319-1.webp\" title=\"Jaunas lapas izveide valod\u0101m\" width=\"844\"\/><\/figure>\n<ul>\n<li>\u0160aj\u0101 jaunaj\u0101 lap\u0101 ievadiet valodu nosaukumus A slej\u0101 un to atbilsto\u0161os kodus B slej\u0101.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Valodas kodu ievad\u012b\u0161ana programm\u0101 Excel\" class=\"wp-image\" decoding=\"async\" height=\"523\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-320-1.webp\" title=\"Valodas kodu ievad\u012b\u0161ana programm\u0101 Excel\" width=\"930\"\/><\/figure>\n<ul>\n<li>\u0160\u016bn\u0101 C1 ierakstiet <code>=TRANSLATE(A1,\"en\",B1)<\/code>un nospiediet tausti\u0146u Enter. Velciet aizpild\u012b\u0161anas turi uz leju, lai autom\u0101tiski \u0123ener\u0113tu tulkojumus atliku\u0161aj\u0101m rind\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Tulko\u0161anas funkcijas aizpild\u012b\u0161ana\" class=\"wp-image\" decoding=\"async\" height=\"497\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-321-1.webp\" title=\"Tulko\u0161anas funkcijas aizpild\u012b\u0161ana\" width=\"883\"\/><\/figure>\n<ul>\n<li>Atgriezieties pie s\u0101kotn\u0113j\u0101s lapas, noklik\u0161\u0137inot uz t\u0101s apak\u0161\u0113j\u0101 kreisaj\u0101 st\u016br\u012b. Atlasiet, kur v\u0113laties pievienot nolai\u017eamo izv\u0113lni valodas atlasei, p\u0113c tam p\u0101rejiet uz cilni &#8220;Dati&#8221; un noklik\u0161\u0137iniet uz &#8220;Datu valid\u0101cija&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Piek\u013cuve datu valid\u0101cijai programm\u0101 Excel\" class=\"wp-image\" decoding=\"async\" height=\"503\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-316-1.webp\" title=\"Piek\u013cuve datu valid\u0101cijai programm\u0101 Excel\" width=\"894\"\/><\/figure>\n<ul>\n<li>Dialoglodzi\u0146\u0101 Datu valid\u0101cija ciln\u0113 &#8220;Iestat\u012bjumi&#8221; atlasiet &#8220;Saraksts&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Datu valid\u0101cijas iestat\u012bjumi\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-317-1.webp\" title=\"Datu valid\u0101cijas iestat\u012bjumi\" width=\"852\"\/><\/figure>\n<ul>\n<li>Lauk\u0101 Avots iez\u012bm\u0113jiet 2.\u00a0lapas \u0161\u016bnas, kur\u0101s ir j\u016bsu valodas opcijas, un p\u0113c tam nospiediet tausti\u0146u Enter. T\u0101d\u0113j\u0101di tiks izveidota nolai\u017eam\u0101 izv\u0113lne ar valod\u0101m, kuras iepriek\u0161 pievienoj\u0101t.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Nolai\u017eamais saraksts ar valodu iesp\u0113j\u0101m\" class=\"wp-image\" decoding=\"async\" height=\"482\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-322-1.webp\" title=\"Nolai\u017eamais saraksts ar valodu iesp\u0113j\u0101m\" width=\"857\"\/><\/figure>\n<ul>\n<li>Izmantojot datu ievadi, pievienojiet funkciju TRANSLATE ar nolai\u017eamo izv\u0113lni, izmantojot: <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\">Svar\u012bgi apsv\u0113rumi<\/h3>\n<ul>\n<li>\u0145emiet v\u0113r\u0101, ka funkcijas TRANSLATE un DETECTLANGUAGE pa\u0161laik var neb\u016bt pieejamas vis\u0101s Excel versij\u0101s, jo t\u0101s tika ieviestas nesen.<\/li>\n<li>Lai p\u0113c tulko\u0161anas saglab\u0101tu vienotu izskatu, apsveriet iesp\u0113ju piel\u0101got fontu izm\u0113rus un stilus, lai piel\u0101gotos da\u017e\u0101da garuma tulkotajam tekstam.<\/li>\n<li>Ja tiek par\u0101d\u012bta k\u013c\u016bda \u201cTeksts ir p\u0101r\u0101k gar\u0161\u201d, m\u0113\u0123iniet samazin\u0101t teksta daudzumu \u0161\u016bn\u0101 vai t\u0101 lielumu, savuk\u0101rt \u201cError in value\u201d nor\u0101da uz elementu, kas nav teksts un kas ir j\u0101no\u0146em. K\u013c\u016bda \u201cNeder\u012bga valoda\u201d parasti rodas no nepareiziem valodu kodiem.<\/li>\n<li>Ab\u0101m funkcij\u0101m ir nepiecie\u0161ams akt\u012bvs interneta savienojums, lai piek\u013c\u016btu Microsoft tulko\u0161anas pakalpojumiem, un lietot\u0101jiem ir j\u0101\u0146em v\u0113r\u0101 ikdienas lieto\u0161anas ierobe\u017eojumi, lai izvair\u012btos no ierobe\u017eo\u0161anas.<\/li>\n<\/ul>\n<h2>Bie\u017ei uzdotie jaut\u0101jumi<\/h2>\n<h3><strong>1. K\u0101 es varu p\u0101rbaud\u012bt, vai mana Excel versija atbalsta funkcijas TRANSLATE un DETECTLANGUAGE?<\/strong><\/h3>\n<p>\u0160o funkciju pieejam\u012bba ir atkar\u012bga no j\u016bsu izmantot\u0101s Excel versijas. P\u0101rbaudiet, vai nav atjaunin\u0101jumu, vai apmekl\u0113jiet ofici\u0101lo Microsoft atbalsta lapu, lai p\u0101rbaud\u012btu, vai tie ir ieviesti j\u016bsu versij\u0101.<\/p>\n<h3><strong>2.\u00a0Kas man j\u0101dara, ja tiek par\u0101d\u012bta k\u013c\u016bda \u201cNeder\u012bga valoda\u201d?<\/strong><\/h3>\n<p>P\u0101rliecinieties, vai formul\u0101 izmantojat pareizo valodas kodu. Ir svar\u012bgi atsaukties uz atjaunin\u0101tu valodu kodu avotu, jo pat nelielas k\u013c\u016bdas var izrais\u012bt \u0161o probl\u0113mu.<\/p>\n<h3><strong>3. Vai es varu izmantot \u0161\u012bs funkcijas bezsaist\u0113?<\/strong><\/h3>\n<p>Diem\u017e\u0113l funkcij\u0101m TRANSLATE un DETECTLANGUAGE ir nepiecie\u0161ams akt\u012bvs interneta savienojums, jo to uzdevumu veik\u0161anai ir nepiecie\u0161ami Microsoft tie\u0161saistes tulko\u0161anas pakalpojumi.<\/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\">Avots un att\u0113li<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Programma Microsoft Excel ir pla\u0161i atz\u012bta par jaud\u012bgu datu p\u0101rvald\u012bbas un anal\u012bzes r\u012bku, tom\u0113r daudzi lietot\u0101ji neapzin\u0101s t\u0101s iesp\u0113jas tulkot valodas un noteikt darbgr\u0101mat\u0101 izmantoto valodu. Jauno funkciju TRANSLATE un DETECTLANGUAGE izmanto\u0161ana var iev\u0113rojami uzlabot j\u016bsu datu p\u0101rvald\u012bbas pieredzi. \u0160\u012bs funkcijas tika palaistas 2024.\u00a0gada decembr\u012b, un t\u0101s ir pieejamas da\u017e\u0101d\u0101s Excel versij\u0101s, tostarp darbvirsm\u0101 (Windows [&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":[130,286],"class_list":["post-7387","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/7387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=7387"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/7387\/revisions"}],"predecessor-version":[{"id":7388,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/7387\/revisions\/7388"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=7387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=7387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=7387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}