{"id":4706,"date":"2023-07-08T18:30:53","date_gmt":"2023-07-08T18:30:53","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/"},"modified":"2023-07-08T18:30:53","modified_gmt":"2023-07-08T18:30:53","slug":"excel-beberapa-pengganti","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/","title":{"rendered":"Excel: cara mengganti beberapa nilai dalam satu sel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk mengganti beberapa nilai dalam sel di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUBSTITUTE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUBSTITUTE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">( <span style=\"color: #3366ff;\">A1<\/span><\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"oldtext1\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"newtext1\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"oldtext2\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"newtext2\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini membuat substitusi berikut pada teks sel <strong>A1<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>teks lama1<\/strong> diganti dengan <strong>teks baru1<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>teks lama2<\/strong> diganti dengan <strong>teks2 baru<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kita mengganti dua nilai dalam sel, tetapi Anda dapat membuat fungsi <strong>SUBSTITUTE<\/strong> bersarang sebanyak yang Anda inginkan untuk mengganti nilai sebanyak yang Anda inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Mengganti beberapa nilai dalam satu sel di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36746 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ub1.png\" alt=\"\" width=\"515\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mengganti \u201cGuard\u201d dengan \u201cGd\u201d. dan &#8220;Maju&#8221; dengan &#8220;Fd&#8221;. untuk setiap nilai di kolom <strong>Posisi<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=SUBSTITUTE(SUBSTITUTE( <span dir=\"auto\" style=\"color: #3366ff;\">B2<\/span> , <span class=\" string \" dir=\"auto\">\"Guard\"<\/span> , <span class=\" string \" dir=\"auto\">\"Gd.\"<\/span> ), <span class=\" string \" dir=\"auto\">\"Forward\"<\/span> , <span class=\" string \" dir=\"auto\">\"Fd.\"<\/span> )\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita akan memasukkan rumus ini di sel <strong>C2<\/strong> , lalu klik dan seret ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36747\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ub2.png\" alt=\"Excel menggantikan beberapa nilai\" width=\"648\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa substitusi berikut telah dilakukan di setiap sel di kolom A:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">String \u201cPenjaga\u201d telah diganti dengan \u201cGd\u201d.<\/span><\/li>\n<li> <span style=\"color: #000000;\">String \u201cMaju\u201d telah digantikan oleh Fd.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika tidak ada string dalam rumus yang ditemukan dalam teks yang Anda cari, rumus hanya akan mengembalikan teks asli tanpa substitusi apa pun.<\/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 tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-antara-dua-karakter\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak teks antara dua karakter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung baris dengan teks di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sumif-berisi-sebagian-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah jika sel berisi sebagian teks di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk mengganti beberapa nilai dalam sel di Excel: = SUBSTITUTE ( SUBSTITUTE ( A1 , &#8220;oldtext1&#8221; , &#8220;newtext1&#8221; ) , &#8220;oldtext2&#8221; , &#8220;newtext2&#8221; ) Rumus khusus ini membuat substitusi berikut pada teks sel A1 : teks lama1 diganti dengan teks baru1 teks lama2 diganti dengan teks2 baru Perhatikan bahwa 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>Excel: Cara mengganti beberapa nilai dalam satu sel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti beberapa nilai dalam satu sel di Excel sekaligus, 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-beberapa-pengganti\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengganti beberapa nilai dalam satu sel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti beberapa nilai dalam satu sel di Excel sekaligus, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T18:30:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ub1.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-beberapa-pengganti\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/\",\"name\":\"Excel: Cara mengganti beberapa nilai dalam satu sel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T18:30:53+00:00\",\"dateModified\":\"2023-07-08T18:30:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti beberapa nilai dalam satu sel di Excel sekaligus, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengganti beberapa nilai dalam satu sel\"}]},{\"@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":"Excel: Cara mengganti beberapa nilai dalam satu sel - Statologi","description":"Tutorial ini menjelaskan cara mengganti beberapa nilai dalam satu sel di Excel sekaligus, 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-beberapa-pengganti\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengganti beberapa nilai dalam satu sel - Statologi","og_description":"Tutorial ini menjelaskan cara mengganti beberapa nilai dalam satu sel di Excel sekaligus, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/","og_site_name":"Statorials","article_published_time":"2023-07-08T18:30:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ub1.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-beberapa-pengganti\/","url":"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/","name":"Excel: Cara mengganti beberapa nilai dalam satu sel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T18:30:53+00:00","dateModified":"2023-07-08T18:30:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti beberapa nilai dalam satu sel di Excel sekaligus, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-beberapa-pengganti\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengganti beberapa nilai dalam satu sel"}]},{"@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\/4706"}],"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=4706"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4706\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}