{"id":5672,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/zleva-a-leftb\/"},"modified":"2021-02-26T09:58:49","modified_gmt":"2021-02-26T09:58:49","slug":"left-leftbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/","title":{"rendered":"ZLEVA a LEFTB"},"content":{"rendered":"<h2>Pou\u017eit\u00ed funkce pro extrakci \u010d\u00e1sti textu zleva<\/h2>\n<p>V Microsoft Excel i v Google Tabulk\u00e1ch existuje velmi u\u017eite\u010dn\u00e1 funkce, kter\u00e1 umo\u017e\u0148uje vyjmout zadan\u00fd po\u010det znak\u016f z lev\u00e9 strany textov\u00e9ho \u0159et\u011bzce. Tato funkce je zn\u00e1m\u00e1 jako ZLEVA (v Excel) nebo LEFT (v Google Tabulk\u00e1ch). Krom\u011b t\u00e9to z\u00e1kladn\u00ed varianty existuje ve verzi pro Microsoft Excel tak\u00e9 varianta LEFTB, kter\u00e1 se pou\u017e\u00edv\u00e1 pro pr\u00e1ci s texty v jazyk\u00e1ch pou\u017e\u00edvaj\u00edc\u00edch dvoubajtovou znakovou sadu.<\/p>\n<h2>Stru\u010dn\u00fd p\u0159ehled syntaxe<\/h2>\n<ul>\n<li><strong>ZLEVA (text; [po\u010det_znak\u016f])<\/strong>: Text je \u0159et\u011bzec, ze kter\u00e9ho chceme vyjmout znaky. Po\u010det_znak\u016f je voliteln\u00fd argument, kter\u00fd ur\u010duje kolik znak\u016f zleva bude vyjmut\u00fdch. Jestli\u017ee tento argument vynech\u00e1te, bude ve v\u00fdchoz\u00edm nastaven\u00ed vyjmut prvn\u00ed znak.<\/li>\n<li><strong>LEFTB (text; [po\u010det_bajt\u016f])<\/strong>: Tato varianta je specifick\u00e1 pro jazyky s dvoubajtov\u00fdm k\u00f3dov\u00e1n\u00edm. Po\u010det_bajt\u016f ud\u00e1v\u00e1, kolik bajt\u016f z lev\u00e9ho konce textov\u00e9ho \u0159et\u011bzce m\u00e1 b\u00fdt vr\u00e1ceno.<\/li>\n<\/ul>\n<pre><code> =ZLEVA(\"Hello World\", 5) \/\/ Vr\u00e1ti \"Hello\" =LEFTB(\"\u3053\u3093\u306b\u3061\u306f\", 4) \/\/ V Excel pro japonsk\u00fd text, vr\u00e1t\u00ed prvn\u00ed dva znaky (ka\u017ed\u00fd japonsk\u00fd znak je obvykle dva bajty). <\/code><\/pre>\n<h2>Praktick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n<p>Pod\u00edvejme se na dva specifick\u00e9 p\u0159\u00edpady, kde m\u016f\u017ee b\u00fdt funkce ZLEVA velmi u\u017eite\u010dn\u00e1:<\/p>\n<h2>Extrakce inici\u00e1l z pln\u00fdch jmen<\/h2>\n<p>P\u0159edstavte si, \u017ee m\u00e1me seznam pln\u00fdch jmen a pot\u0159ebujeme z\u00edskat pouze prvn\u00ed p\u00edsmena ka\u017ed\u00e9ho jm\u00e9na. S pou\u017eit\u00edm funkce ZLEVA m\u016f\u017eeme snadno a rychle z\u00edskat po\u017eadovan\u00fd v\u00fdsledek.<\/p>\n<pre><code> =ZLEVA(\"Jan Nov\u00e1k\", 1) \/\/ Vr\u00e1ti \"J\" =ZLEVA(\"Petr Svoboda\", 1) \/\/ Vr\u00e1ti \"P\" <\/code><\/pre>\n<p>T\u00edmto zp\u016fsobem m\u016f\u017eeme prost\u0159ednictv\u00edm funkce snadno z\u00edskat inici\u00e1ly u\u017eivatel\u016f, kter\u00e9 nap\u0159\u00edklad m\u016f\u017eeme pou\u017e\u00edt ve vlastn\u00edch datab\u00e1z\u00edch \u010di p\u0159i generov\u00e1n\u00ed u\u017eivatelsk\u00fdch jmen.<\/p>\n<h2>Pr\u00e1ce s daty ve form\u00e1tu CSV<\/h2>\n<p>\u010casto se setk\u00e1v\u00e1me s nutnost\u00ed zpracov\u00e1vat textov\u00e1 data ve form\u00e1tu CSV, kde jsou jednotliv\u00e9 hodnoty odd\u011bleny \u010d\u00e1rkami. Pokud n\u00e1s zaj\u00edm\u00e1 prvn\u00ed pole v ka\u017ed\u00e9m \u0159\u00e1dku, m\u016f\u017eeme op\u011bt vyu\u017e\u00edt funkci ZLEVA spole\u010dn\u011b s funk\u010dn\u00edm kombin\u00e1torem NAJ\u00cdT pro lokalizaci prvn\u00ed \u010d\u00e1rky.<\/p>\n<pre><code> =ZLEVA(A1, NAJ\u00cdT(\",\", A1)-1) <\/code><\/pre>\n<p>Na p\u0159edchoz\u00edm p\u0159\u00edkladu A1 je bu\u0148ka, kter\u00e1 obsahuje text CSV, jako nap\u0159\u00edklad &#8222;12345,67890,ABCDEF&#8220;. V\u00fdsledkem aplikace funkce bude &#8222;12345&#8220;, co\u017e je text p\u0159ed prvn\u00ed \u010d\u00e1rkou.<\/p>\n<p>Tyto praktick\u00e9 p\u0159\u00edklady ukazuj\u00ed, jak m\u016f\u017ee b\u00fdt funkce ZLEVA neoceniteln\u00fdm n\u00e1strojem v \u0161irok\u00e9 \u0161k\u00e1le aplikac\u00ed p\u0159i zpracov\u00e1n\u00ed textov\u00fdch dat ve va\u0161ich tabulkov\u00fdch dokumentech.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vr\u00e1t\u00ed prvn\u00ed znaky textov\u00e9 hodnoty um\u00edst\u011bn\u00e9 nejv\u00edce vlevo<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[286],"tags":[],"class_list":["post-5672","post","type-post","status-publish","format-standard","hentry","category-textove"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije LEFT, LEFTBs (ZLEVA a LEFTB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije LEFT, LEFTBs (ZLEVA a LEFTB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:58:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/\",\"name\":\"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:58:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije LEFT, LEFTBs (ZLEVA a LEFTB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/left-leftbs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Textov\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/textove\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ZLEVA a LEFTB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije LEFT, LEFTBs (ZLEVA a LEFTB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije LEFT, LEFTBs (ZLEVA a LEFTB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:58:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/","url":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/","name":"Funkce LEFT, LEFTBs (ZLEVA a LEFTB) v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:58:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije LEFT, LEFTBs (ZLEVA a LEFTB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/left-leftbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/left-leftbs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Textov\u00e9","item":"https:\/\/functiontranslator.com\/cs\/textove\/"},{"@type":"ListItem","position":3,"name":"ZLEVA a LEFTB"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5672"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5672\/revisions"}],"predecessor-version":[{"id":30810,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5672\/revisions\/30810"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}