{"id":4707,"date":"2023-07-08T18:28:07","date_gmt":"2023-07-08T18:28:07","guid":{"rendered":"https:\/\/statorials.org\/id\/pengganti-excel-joker\/"},"modified":"2023-07-08T18:28:07","modified_gmt":"2023-07-08T18:28:07","slug":"pengganti-excel-joker","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pengganti-excel-joker\/","title":{"rendered":"Excel: cara menggunakan fungsi substitute dengan wildcard"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan fungsi SUBSTITUTE<\/strong> di Excel untuk mengganti substring tertentu dalam sel dengan substring lain.<\/span><\/p>\n

Sayangnya, fungsi SUBSTITUTE<\/strong> tidak bekerja dengan wildcard.<\/span><\/p>\n

Namun, Anda bisa menggunakan rumus berikut untuk mengganti teks dalam sel menggunakan pendekatan yang mirip dengan menggunakan wildcard:<\/span><\/p>\n

 =IFERROR(LEFT( A2<\/span> ,FIND(\"Mavs\", A2<\/span> )+LEN(\"Mavs\"))&\"are an awesome \"&RIGHT( A2<\/span> ,LEN( A2<\/span> )-FIND(\"team\", A2<\/span> )+LEN(\" team\")-3), A2<\/span> )\n<\/span><\/strong><\/span><\/pre>\n
 Rumus khusus ini menggunakan kombinasi fungsi LEFT<\/strong> , RIGHT<\/strong> , FIND<\/strong> , dan LEN<\/strong> untuk mengganti semua teks di sel A1<\/strong> antara string “Mavs” dan “team” dengan teks “are an awesome”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Ganti Teks Menggunakan Wildcard di Excel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar ekspresi berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk mengganti semua teks di sel A2<\/strong> antara string “Mavs” dan “team” dengan teks “are an awesome”.<\/span><\/p>\n
 =IFERROR(LEFT( A2<\/span> ,FIND(\"Mavs\", A2<\/span> )+LEN(\"Mavs\"))&\"are an awesome \"&RIGHT( A2<\/span> ,LEN( A2<\/span> )-FIND(\"team\", A2<\/span> )+LEN(\" team\")-3), A2<\/span> )\n<\/span><\/strong><\/span><\/pre>\n
 Kita akan memasukkan rumus ini di sel B2<\/strong> , lalu klik dan seret ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n
\"PENGGANTI<\/p>\n
 Perhatikan bahwa semua teks antara string “Mavs” dan “team” telah diganti dengan teks “are an awesome”.<\/span><\/p>\n
 Perhatikan bahwa kita menggunakan fungsi IFERROR<\/strong> untuk menentukan bahwa jika “Mavs” dan “tim” tidak dapat ditemukan, kita cukup mengembalikan kalimat asli dari kolom A.<\/span><\/p>\n
 Tanpa fungsi IFERROR<\/strong> , rumusnya akan menghasilkan #VALUE!<\/strong> error jika string yang kita cari tidak ditemukan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara mengekstrak teks antara dua karakter di Excel<\/a>
 Cara menghitung baris dengan teks di Excel<\/a>
 Cara menghitung jumlah jika sel berisi sebagian teks di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan fungsi SUBSTITUTE di Excel untuk mengganti substring tertentu dalam sel dengan substring lain. Sayangnya, fungsi SUBSTITUTE tidak bekerja dengan wildcard. Namun, Anda bisa menggunakan rumus berikut untuk mengganti teks dalam sel menggunakan pendekatan yang mirip dengan menggunakan wildcard: =IFERROR(LEFT( A2 ,FIND(“Mavs”, A2 )+LEN(“Mavs”))&”are an awesome “&RIGHT( A2 ,LEN( A2 )-FIND(“team”, A2 )+LEN(” […]<\/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":"\nExcel: Cara menggunakan fungsi SUBSTITUTE dengan wildcard - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUBSTITUTE di Excel dengan wildcard, 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\/pengganti-excel-joker\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan fungsi SUBSTITUTE dengan wildcard - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUBSTITUTE di Excel dengan wildcard, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pengganti-excel-joker\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T18:28:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subwild.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\/pengganti-excel-joker\/\",\"url\":\"https:\/\/statorials.org\/id\/pengganti-excel-joker\/\",\"name\":\"Excel: Cara menggunakan fungsi SUBSTITUTE dengan wildcard - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T18:28:07+00:00\",\"dateModified\":\"2023-07-08T18:28:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi SUBSTITUTE di Excel dengan wildcard, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pengganti-excel-joker\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pengganti-excel-joker\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pengganti-excel-joker\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan fungsi substitute dengan wildcard\"}]},{\"@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 menggunakan fungsi SUBSTITUTE dengan wildcard - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi SUBSTITUTE di Excel dengan wildcard, 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\/pengganti-excel-joker\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan fungsi SUBSTITUTE dengan wildcard - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi SUBSTITUTE di Excel dengan wildcard, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/pengganti-excel-joker\/","og_site_name":"Statorials","article_published_time":"2023-07-08T18:28:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subwild.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\/pengganti-excel-joker\/","url":"https:\/\/statorials.org\/id\/pengganti-excel-joker\/","name":"Excel: Cara menggunakan fungsi SUBSTITUTE dengan wildcard - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T18:28:07+00:00","dateModified":"2023-07-08T18:28:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi SUBSTITUTE di Excel dengan wildcard, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pengganti-excel-joker\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pengganti-excel-joker\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pengganti-excel-joker\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan fungsi substitute dengan wildcard"}]},{"@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\/4707"}],"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=4707"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4707\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}