{"id":5089,"date":"2023-07-03T21:15:18","date_gmt":"2023-07-03T21:15:18","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/"},"modified":"2023-07-03T21:15:18","modified_gmt":"2023-07-03T21:15:18","slug":"excel-ganti-jika-sel-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/","title":{"rendered":"Rumus excel: ganti jika sel berisi teks tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda dapat menggunakan fitur <strong>Temukan dan Ganti<\/strong> di Excel untuk mengganti teks dalam sel hanya jika sel tersebut berisi teks tertentu.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fitur ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Ganti jika sel berisi teks tertentu di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan nama dan posisi berbagai pemain bola basket dalam sebuah tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39647 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerif1.png\" alt=\"\" width=\"484\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mengganti semua teks di setiap sel di kolom <strong>Posisi<\/strong> yang berisi &#8220;Mulai&#8221; di mana saja di dalam sel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, sorot rentang sel <strong>B2:B13<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketik <strong>Ctrl + H<\/strong> untuk menampilkan jendela <strong>Temukan dan Ganti<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu ketik <strong>*Startup*<\/strong> di kotak <strong>Pencarian<\/strong> , lalu ketik Starter di kotak <strong>Ganti dengan<\/strong> :.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39648 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerif2.png\" alt=\"\" width=\"656\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tombol <strong>Ganti Semua<\/strong> di pojok kiri bawah jendela.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Teks di setiap sel yang berisi <strong>Mulai<\/strong> di mana saja di dalam sel kini akan diganti dengan <strong>Starter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39649\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerif3.png\" alt=\"Ganti Excel jika berisi\" width=\"544\" height=\"534\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan juga muncul yang memberitahu kita bahwa total <strong>3<\/strong> penggantian telah dilakukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita menggunakan tanda bintang di kotak <strong>Temukan<\/strong> (*Mulai*) untuk menentukan bahwa kita ingin mengganti semua teks dalam sel jika berisi &#8220;Mulai&#8221; di mana pun dalam string.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda hanya ingin mengganti teks &#8220;Startup&#8221; dengan &#8220;Starter&#8221;, hilangkan tanda bintang di kotak <strong>Temukan<\/strong> saat menggunakan <strong>Temukan dan Ganti<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti sel kosong dengan nol di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti beberapa nilai dalam satu sel di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fitur Temukan dan Ganti di Excel untuk mengganti teks dalam sel hanya jika sel tersebut berisi teks tertentu. Contoh berikut menunjukkan cara menggunakan fitur ini dalam praktiknya. Contoh: Ganti jika sel berisi teks tertentu di Excel Misalkan kita memiliki kumpulan data berikut yang menunjukkan nama dan posisi berbagai pemain bola basket dalam [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Rumus Excel: ganti jika sel berisi teks tertentu - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti teks di Excel jika sel berisi teks tertentu, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rumus Excel: ganti jika sel berisi teks tertentu - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti teks di Excel jika sel berisi teks tertentu, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T21:15:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerif1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/\",\"name\":\"Rumus Excel: ganti jika sel berisi teks tertentu - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T21:15:18+00:00\",\"dateModified\":\"2023-07-03T21:15:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti teks di Excel jika sel berisi teks tertentu, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rumus excel: ganti jika sel berisi teks tertentu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rumus Excel: ganti jika sel berisi teks tertentu - Statologi","description":"Tutorial ini menjelaskan cara mengganti teks di Excel jika sel berisi teks tertentu, beserta contohnya.","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:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"Rumus Excel: ganti jika sel berisi teks tertentu - Statologi","og_description":"Tutorial ini menjelaskan cara mengganti teks di Excel jika sel berisi teks tertentu, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-03T21:15:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerif1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/","url":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/","name":"Rumus Excel: ganti jika sel berisi teks tertentu - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T21:15:18+00:00","dateModified":"2023-07-03T21:15:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti teks di Excel jika sel berisi teks tertentu, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-ganti-jika-sel-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Rumus excel: ganti jika sel berisi teks tertentu"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5089"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=5089"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5089\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}