{"id":306,"date":"2020-05-14T16:35:17","date_gmt":"2020-05-14T16:35:17","guid":{"rendered":"https:\/\/bethecoach.pl\/?p=306"},"modified":"2026-04-01T11:37:59","modified_gmt":"2026-04-01T11:37:59","slug":"find-and-replace-podmieniaj-wartosci","status":"publish","type":"post","link":"https:\/\/bethecoach.pl\/index.php\/2020\/05\/14\/find-and-replace-podmieniaj-wartosci\/","title":{"rendered":"Find and Replace. Podmieniaj warto\u015bci."},"content":{"rendered":"\n<p>Bardzo przydatnymi funkcjami, cz\u0119sto wykorzystywanymi w pracy biurowej w Excelu s\u0105 <strong>funkcje <em>Find<\/em> (Znajd\u017a) i <em>Replace<\/em> (Zamie\u0144)<\/strong>. Dzi\u015b kilka s\u0142\u00f3w o tych do\u015b\u0107 prostych, ale niezwykle przydatnych funkcjach.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Kurs Excel #6 Find and Replace - Szukaj i Podmieniaj warto\u015bci w Excelu\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8OtTMYz4YLw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<!--more-->\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Posiadaj\u0105c rozbudowany arkusz danych, cz\u0119sto chcemy przejrze\u0107 jedynie interesuj\u0105cy nas wycinek. W Excelu mamy <strong>metod\u0119, dzi\u0119ki kt\u00f3rej mo\u017cemy szuka\u0107 warto\u015bci w arkuszu. Ta metoda to metoda <em>Find<\/em>.<\/strong> Aby znale\u017a\u0107 warto\u015b\u0107 w arkuszu przejd\u017a do opcji znajd\u017a poprzez wybranie opcji <em>Find &amp; Select<\/em> z sekcji <em>Editing<\/em> zak\u0142adki <em>Home<\/em>.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"322\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-1024x322.jpg\" alt=\"\" class=\"wp-image-307\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-1024x322.jpg 1024w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-300x94.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-768x242.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-24x8.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-36x11.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select-48x15.jpg 48w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-select.jpg 1356w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Znalezienie metody Find<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Znajduje si\u0119 tam r\u00f3wnie\u017c<strong> opcja <em>Replace<\/em><\/strong>, kt\u00f3r\u0105 zajmiemy si\u0119 p\u00f3\u017aniej.<\/p>\n\n\n\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>W podstawowej wersji metody <em>Find<\/em>, wystarczy wpisa\u0107 szukan\u0105 fraz\u0119 i nacisn\u0105\u0107 <em>Find Next<\/em> (znalezienie nast\u0119pnego napotkanego dopasowania) lub <em>Find All<\/em> (znalezienie wszystkich wyst\u0105pie\u0144).<\/p>\n\n\n\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"397\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-1024x397.jpg\" alt=\"\" class=\"wp-image-308\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-1024x397.jpg 1024w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-300x116.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-768x298.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-24x9.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-36x14.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next-48x19.jpg 48w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-next.jpg 1365w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Wyszukanie kolejnego wyst\u0105pienia<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:57px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-1024x474.jpg\" alt=\"\" class=\"wp-image-309\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-1024x474.jpg 1024w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-300x139.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-768x356.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-24x11.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-36x17.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all-48x22.jpg 48w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/find-all.jpg 1343w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Wyszukanie wszystkich wyst\u0105pie\u0144 w przeszukiwanym zakresie<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Po rozwini\u0119ciu opcji<em> <strong>Options >><\/strong><\/em> b\u0119dziemy mogli modyfikowa\u0107 nasze wyszukiwanie. <strong>Mo\u017cna zmieni\u0107 metod\u0119 wyszukiwania, rodzaju danych jaki chcemy szuka\u0107 oraz zakresu przeszukiwania.<\/strong><\/p>\n\n\n\n<div style=\"height:37px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"262\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/rozwiniecie-options.jpg\" alt=\"\" class=\"wp-image-310\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/rozwiniecie-options.jpg 485w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/rozwiniecie-options-300x162.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/rozwiniecie-options-24x13.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/rozwiniecie-options-36x19.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/rozwiniecie-options-48x26.jpg 48w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><figcaption>Opcje przeszukiwania<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:34px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Jak ju\u017c przy zakresie mowa to warto wspomnie\u0107 og\u00f3lne zasady przeszukiwania. <strong>Szukanie b\u0119dzie odbywa\u0107 si\u0119 w zaznaczonym obszarze. Je\u015bli nie zaznaczymy \u017cadnego obszaru (b\u0119dziemy mie\u0107 pod\u015bwietlon\u0105 jedn\u0105 kom\u00f3rk\u0119) to metoda przeszuka ca\u0142y arkusz.<\/strong><\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Kolejn\u0105 opcj\u0105 jest metoda <em>Replace<\/em>.<\/strong> Uruchamiamy j\u0105 z tego samego menu co metod\u0119 Find. Zach\u0119cam jednak do u\u017cywania skr\u00f3tu klawiaturowego. <strong>Aby uruchomi\u0107 okno metod <em>Find<\/em> i <em>Replace <\/em>wystarczy ze naci\u015bniesz skr\u00f3t klawiaturowy Ctrl + f.<\/strong><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Metoda <em>Replace<\/em> r\u00f3\u017cni si\u0119 tym od metody <em>Find<\/em>, \u017ce <strong>wyszukany fragment wpisany w polu <em>Find what<\/em>, zostanie zast\u0105piony fragmentem z pole <em>Replace with<\/em>.<\/strong> To wa\u017cne, nie musimy znajdowa\u0107 pe\u0142nej warto\u015bci\u00a0 kom\u00f3rce \u2013 Excel poradzi sobie z wyszukaniem tylko cz\u0119\u015bci warto\u015bci znajduj\u0105cej si\u0119 w niej. <\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"386\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-1024x386.jpg\" alt=\"\" class=\"wp-image-312\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-1024x386.jpg 1024w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-300x113.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-768x290.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-24x9.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-36x14.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace-48x18.jpg 48w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/replace.jpg 1053w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Metoda Replace<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Je\u017celi pole <em>Replace<\/em> with zostawimy puste, Excel usunie z kolejnej znalezionej warto\u015bci to co wpisali\u015bmy w <em>Find what<\/em>. Po naci\u015bni\u0119ciu przycisku <em>Replace,<\/em> w nast\u0119pnej znalezionej warto\u015bci nast\u0105pi podmiana. <strong>Je\u015bli u\u017cyjemy <em>Replace all<\/em> to we wszystkich znalezionych przypadkach wybranego zakresu Excel podmieni warto\u015bci.<\/strong> Warto uwa\u017ca\u0107, aby nie podmieni\u0107 przez przypadek warto\u015bci, kt\u00f3re chcemy zostawi\u0107. Na przyk\u0142ad maj\u0105c kolumn\u0119, w kt\u00f3rej chcemy zamieni\u0107 znaki kropek na przecinki, mo\u017cemy zaznaczy\u0107 t\u0105 kolumn\u0119 i dopiero wybra\u0107 opcj\u0119 <em>Replace all<\/em>. W ten spos\u00f3b nie podmienimy kropek w innych kolumnach.<\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"399\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-1024x399.jpg\" alt=\"\" class=\"wp-image-311\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-1024x399.jpg 1024w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-300x117.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-768x300.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-24x9.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-36x14.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek-48x19.jpg 48w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/zamienianie-kropek.jpg 1064w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Zamienianie warto\u015bci w kolumnie<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:38px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Je\u015bli chodzi o funkcj\u0119 <em>Find i Replace<\/em> to wszystko \u2013 po wi\u0119cej zach\u0119cam Ci\u0119 do obejrzenia nagrania. Te funkcje b\u0119d\u0105 si\u0119 przewija\u0107 w dalszej pracy z Excelem, a w kolejnych odcinkach dowiemy si\u0119 jak szuka\u0107 wielu wyst\u0105pie\u0144 poprzez <strong>filtrowanie danych<\/strong>. Zapraszam!<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Kurs Excel #6 Find and Replace - Szukaj i Podmieniaj warto\u015bci w Excelu\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8OtTMYz4YLw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Bardzo przydatnymi funkcjami, cz\u0119sto wykorzystywanymi w pracy biurowej w Excelu s\u0105 funkcje Find (Znajd\u017a) i Replace (Zamie\u0144). Dzi\u015b kilka s\u0142\u00f3w o tych do\u015b\u0107 prostych, ale niezwykle przydatnych funkcjach.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-306","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/comments?post=306"}],"version-history":[{"count":2,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/306\/revisions"}],"predecessor-version":[{"id":314,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/306\/revisions\/314"}],"wp:attachment":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/media?parent=306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/categories?post=306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/tags?post=306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}