{"id":5778,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/nahradit-a-nahraditb\/"},"modified":"2021-02-26T10:02:32","modified_gmt":"2021-02-26T10:02:32","slug":"replace-replacebs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/","title":{"rendered":"NAHRADIT a NAHRADITB"},"content":{"rendered":"

Excel a Google Sheets nab\u00edzej\u00ed funkce NAHRADIT a NAHRADITB, kter\u00e9 umo\u017e\u0148uj\u00ed efektivn\u011b manipulovat s textov\u00fdmi \u0159et\u011bzci. Funkce NAHRADIT umo\u017e\u0148uje nahradit specifickou \u010d\u00e1st textu nov\u00fdm textem, p\u0159i\u010dem\u017e jeden znak je po\u010d\u00edt\u00e1n jako jeden bez ohledu na jeho \u0161\u00ed\u0159ku. Naproti tomu, NAHRADITB zohled\u0148uje dvojbytov\u00e9 znaky \u2013 to je zvl\u00e1\u0161t\u011b u\u017eite\u010dn\u00e9 p\u0159i pr\u00e1ci s jazyky jako jsou japon\u0161tina nebo \u010d\u00edn\u0161tina, kde ka\u017ed\u00fd dvojbytov\u00fd znak je po\u010d\u00edt\u00e1n jako dva znaky.<\/p>\n

Syntaxe a pou\u017eit\u00ed<\/h2>\n

Syntaxe pro funkci NAHRADIT je v Excelu i Google Sheets n\u00e1sleduj\u00edc\u00ed:<\/p>\n

 NAHRADIT(p\u016fvodn\u00ed_text, pozice_zacatek, pocet_znaku, novy_text)<\/code> <\/pre>\n
    \n
  • p\u016fvodn\u00ed_text<\/b> – Text, nebo odkaz na bu\u0148ku obsahuj\u00edc\u00ed text, kde chcete prov\u00e9st zm\u011bnu.<\/li>\n
  • pozice_zacatek<\/b> – Pozice v textu, kde za\u010dne nahrazov\u00e1n\u00ed.<\/li>\n
  • pocet_znaku<\/b> – Kolik znak\u016f z p\u016fvodn\u00edho textu m\u00e1 b\u00fdt nahrazeno.<\/li>\n
  • novy_text<\/b> – Text, kter\u00fd m\u00e1 nahradit vybran\u00e9 znaky.<\/li>\n<\/ul>\n
    Pro funkci NAHRADITB syntaxe vypad\u00e1 stejn\u011b:<\/p>\n
     NAHRADITB(p\u016fvodn\u00ed_text, pozice_zacatek, pocet_znaku, novy_text)<\/code> <\/pre>\n
    P\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n\n\n\n\n
    P\u0159\u00edklad<\/th>\nVzorec<\/th>\nV\u00fdsledek<\/th>\n<\/tr>\n
    Zm\u011bna ‚abc‘ na ‚abXYZ‘ v textu ‚abcdef‘<\/td>\nNAHRADIT(\"abcdef\", 3, 3, \"XYZ\")<\/code><\/td>\n‚abXYZef‘<\/td>\n<\/tr>\n
    Odebr\u00e1n\u00ed prvn\u00edch 3 znak\u016f z textu ‚12345‘ a nahrazen\u00ed nov\u00fdm textem ‚abc‘<\/td>\nNAHRADIT(\"12345\", 1, 3, \"abc\")<\/code><\/td>\n‚abc45‘<\/td>\n<\/tr>\n<\/table>\n
    P\u0159\u00edklady v praxi<\/h2>\n
    1. P\u0159\u00edklad – Form\u00e1tov\u00e1n\u00ed telefonn\u00edch \u010d\u00edsel:<\/p>\n
    P\u0159edpokl\u00e1dejme, \u017ee m\u00e1me seznam telefonn\u00edch \u010d\u00edsel ve form\u00e1tu ‚1234567890‘ a pot\u0159ebujeme je p\u0159eform\u00e1tovat na ‚(123) 456-7890‘. Pou\u017eijeme funkci NAHRADIT takto:<\/p>\n
     NAHRADIT(NAHRADIT(\"1234567890\", 1, 0, \"(\"), 5, 0, \") \"), 10, 0, \"-\")<\/code> <\/pre>\n
    Vkl\u00e1d\u00e1me ‚(‚ na za\u010d\u00e1tek, pak ‚)‘ po t\u0159et\u00edm znaku, a nakonec ‚-‚ po \u0161est\u00e9m znaku.<\/p>\n
    2. P\u0159\u00edklad – Zpracov\u00e1n\u00ed XML tag\u016f:<\/p>\n
    P\u0159edstavte si, \u017ee pot\u0159ebujeme v XML souboru nahradit tag <name> tagem <fullName>. Pou\u017eijeme NAHRADIT takto:<\/p>\n
     NAHRADIT(NAHRADIT(\"<name>Jan Nov\u00e1k<\/name>\", 2, 4, \"fullName\"), 14, 4, \"fullName\")<\/code> <\/pre>\n
    Nejd\u0159\u00edve nahrazujeme ‚name‘ slovem ‚fullName‘ ve startovac\u00edm tagu a pot\u00e9 prov\u00e1d\u00edme stejnou zm\u011bnu v uzav\u00edrac\u00edm tagu.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Nahrad\u00ed znaky uvnit\u0159 textu<\/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-5778","post","type-post","status-publish","format-standard","hentry","category-textove"],"acf":[],"yoast_head":"\nFunkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) 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\/replace-replacebs\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/\" \/>\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-26T10:02:32+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) 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\/replace-replacebs\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/\",\"name\":\"Funkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) 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-26T10:02:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/#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\":\"NAHRADIT a NAHRADITB\"}]},{\"@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 REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) 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\/replace-replacebs\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T10:02:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) 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\/replace-replacebs\/","url":"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/","name":"Funkce REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) 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-26T10:02:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije REPLACE, REPLACEBs (NAHRADIT a NAHRADITB) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/replace-replacebs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/replace-replacebs\/#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":"NAHRADIT a NAHRADITB"}]},{"@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\/5778","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=5778"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5778\/revisions"}],"predecessor-version":[{"id":30916,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5778\/revisions\/30916"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}