{"id":11832,"date":"2016-10-25T13:25:56","date_gmt":"2016-10-25T12:25:56","guid":{"rendered":"http:\/\/www.bestonline.cz\/?p=11832"},"modified":"2021-05-11T23:27:41","modified_gmt":"2021-05-11T21:27:41","slug":"nahrazeni-textu-v-bunkach-v-excelu","status":"publish","type":"post","link":"https:\/\/www.bestonline.cz\/nahrazeni-textu-v-bunkach-v-excelu\/","title":{"rendered":"Nahrazen\u00ed textu v bu\u0148k\u00e1ch v\u00a0Excelu"},"content":{"rendered":"<p>P\u0159in\u00e1\u0161\u00edme V\u00e1m rychl\u00fd tip na to, jak prov\u00e9st nap\u0159\u00edklad hromadn\u00e9 odebr\u00e1n\u00ed znak\u016f (v na\u0161em p\u0159\u00edpad\u011b \u010d\u00e1rek) ze sloupce v\u00a0excelovsk\u00e9 tabulce. Stejn\u011b tak touto funkc\u00ed m\u016f\u017eete nahrazovat slova.<\/p>\n<p>1. Vybereme si bu\u0148ky, ve kter\u00fdch chceme znak odebrat, nebo p\u0159idat. U m\u011b to bude cel\u00fd sloupec B, ze kter\u00e9ho chci odebrat uvozovky.<br \/>\n<a href=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/odebrani-pridani-ci-nahrazeni-slova-v-excelu.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-11836\" src=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/odebrani-pridani-ci-nahrazeni-slova-v-excelu.png\" alt=\"odebrani-pridani-ci-nahrazeni-slova-v-excelu\" width=\"197\" height=\"476\" title=\"\"><\/a><br \/>\n2. V\u00a0prav\u00e9m horn\u00edm rohu klikneme na ikonu naj\u00edt a nahradit a zvol\u00edme mo\u017enost nahradit. Kl\u00e1vesov\u00e1 zkratka je CTRL+H.<br \/>\n<a href=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/najit-a-nahradit-excel-2016.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-11834\" src=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/najit-a-nahradit-excel-2016.png\" alt=\"najit-a-nahradit-excel-2016\" width=\"235\" height=\"401\" title=\"\"><\/a><br \/>\n3. Do n\u00e1sledn\u011b otev\u0159en\u00e9ho formul\u00e1\u0159e vypln\u00edm kolonku \u201eNaj\u00edt\u201c a \u201eNahradit\u201c. V\u00a0m\u00e9m p\u0159\u00edpad\u011b tedy Naj\u00edt: \u201c a jeliko\u017e chci uvozovky smazat, pole nahradit, nech\u00e1m pr\u00e1zdn\u00e9.<br \/>\n<a href=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/najit-a-nahradit-dialogove-okno-excel-2016.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-11833\" src=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/najit-a-nahradit-dialogove-okno-excel-2016.png\" alt=\"najit-a-nahradit-dialogove-okno-excel-2016\" width=\"451\" height=\"197\" title=\"\"><\/a><br \/>\n4. Stisknu Nahradit v\u0161e a akce se provede na v\u0161echna ozna\u010den\u00e1 pole.<br \/>\n<a href=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/nalezeno-a-nahrazeno-excel.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-11835\" src=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/nalezeno-a-nahrazeno-excel.png\" alt=\"nalezeno-a-nahrazeno-excel\" width=\"442\" height=\"115\" title=\"\"><\/a><br \/>\n5. V\u00fdsledek, je p\u0159esn\u011b takov\u00fd, jak\u00fd jsme ho cht\u011bli. Je to jednoduch\u00e9 a uleh\u010d\u00ed to spoustu pr\u00e1ce. To sam\u00e9 m\u016f\u017eete prov\u00e9st v\u00a0p\u0159\u00edpad\u011b, \u017ee chcete nahradit slovo nap\u0159\u00edklad mezerou, nebo jin\u00fdm slovem. To u\u017e si m\u016f\u017eete vyzkou\u0161et sami.<br \/>\n<a href=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/vysledek-odebrani-pridani-ci-nahrazeni-slova-v-excelu.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-11837\" src=\"http:\/\/www.bestonline.cz\/wp-content\/uploads\/2015\/12\/vysledek-odebrani-pridani-ci-nahrazeni-slova-v-excelu.png\" alt=\"vysledek-odebrani-pridani-ci-nahrazeni-slova-v-excelu\" width=\"199\" height=\"386\" title=\"\"><\/a><\/p>\n<p>Nem\u00e1te kancel\u00e1\u0159skou sadu Office? Prohl\u00e9dn\u011bte si <a href=\"http:\/\/www.bestonline.cz\/microsoft-office-365\/\">pl\u00e1ny Office 365 pro firmy<\/a>, nebo pl\u00e1ny Office 365 pro dom\u00e1cnosti na str\u00e1nce <a href=\"http:\/\/www.bestonlineshop.cz\/\" target=\"_blank\" rel=\"noopener\">bestonlineshop.cz<\/a>.<\/p>\n<p>V\u00a0p\u0159\u00edpad\u011b jak\u00fdchkoliv dotaz\u016f, n\u00e1s nev\u00e1hejte kontaktovat na na\u0161\u00ed HOTLINE 555 501 810.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>P\u0159in\u00e1\u0161\u00edme V\u00e1m rychl\u00fd tip na to, jak prov\u00e9st nap\u0159\u00edklad hromadn\u00e9 odebr\u00e1n\u00ed znak\u016f (v na\u0161em p\u0159\u00edpad\u011b \u010d\u00e1rek) ze sloupce v\u00a0excelovsk\u00e9 tabulce. Stejn\u011b tak touto funkc\u00ed m\u016f\u017eete nahrazovat slova.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/posts\/11832"}],"collection":[{"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/comments?post=11832"}],"version-history":[{"count":1,"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/posts\/11832\/revisions"}],"predecessor-version":[{"id":60932,"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/posts\/11832\/revisions\/60932"}],"wp:attachment":[{"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/media?parent=11832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/categories?post=11832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bestonline.cz\/wp-json\/wp\/v2\/tags?post=11832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}