{"id":2742,"date":"2023-07-20T22:18:28","date_gmt":"2023-07-20T22:18:28","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/"},"modified":"2023-07-20T22:18:28","modified_gmt":"2023-07-20T22:18:28","slug":"excel-menghapus-teks-tertentu-dari-sel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/","title":{"rendered":"Excel: cara menghapus teks tertentu dari sel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk menghapus teks tertentu dari sel di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hapus teks tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE( <span style=\"color: #3366ff;\">A1<\/span> ,\"text1\",\"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghapus &#8220;text1&#8221; dari sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: hapus beberapa teks tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( <span style=\"color: #3366ff;\">A1<\/span> ,\"text1\",\"\"),\"text2\",\"\"),\"text3\",\"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghapus &#8220;text1, &#8220;text2&#8221; dan &#8220;text3&#8221; dari sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: menghapus teks tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kolom berikut di Excel yang memperlihatkan posisi 15 pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24135 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subst1.jpg\" alt=\"\" width=\"424\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghapus &#8220;r&#8221; dari setiap nama pekerjaan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"r\",\"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu menyalin dan menempelkannya ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24136\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subst2.jpg\" alt=\"Excel menghapus teks tertentu dari sel\" width=\"495\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa \u201cr\u201d telah dihapus dari setiap nama posisi.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hapus beberapa teks tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kolom berikut di Excel yang menampilkan nama pengguna 10 orang berbeda di sebuah situs web:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24138 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subst3.jpg\" alt=\"\" width=\"414\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghapus teks spesifik berikut dari setiap nama pengguna:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">tanda hubung ( <strong>\u2013<\/strong> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">tanda seru ( <strong>!<\/strong> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">nomor 5 ( <strong>5<\/strong> )<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"-\",\"\"),\"!\",\"\"),\"5\",\"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu menyalin dan menempelkannya ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24139 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subst4.jpg\" alt=\"\" width=\"476\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua tanda \u201c\u2013\u201d, \u201c!\u201d &#8221; dan &#8220;5&#8221; telah dihapus dari setiap nama pengguna.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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-jika-berisi-sebagian-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memeriksa apakah sel berisi sebagian teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memeriksa apakah sel berisi teks daftar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung rata-rata jika sel berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung frekuensi teks<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus dasar berikut untuk menghapus teks tertentu dari sel di Excel: Metode 1: Hapus teks tertentu =SUBSTITUTE( A1 ,&#8221;text1&#8243;,&#8221;&#8221;) Rumus khusus ini menghapus &#8220;text1&#8221; dari sel A1 . Metode 2: hapus beberapa teks tertentu =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( A1 ,&#8221;text1&#8243;,&#8221;&#8221;),&#8221;text2&#8243;,&#8221;&#8221;),&#8221;text3&#8243;,&#8221;&#8221;) Rumus khusus ini menghapus &#8220;text1, &#8220;text2&#8221; dan &#8220;text3&#8221; dari sel A1 . Contoh berikut menunjukkan [&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 menghapus teks tertentu dari sel - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus teks tertentu dari sel di Excel, dengan beberapa contoh.\" \/>\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-menghapus-teks-tertentu-dari-sel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghapus teks tertentu dari sel - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus teks tertentu dari sel di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:18:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subst1.jpg\" \/>\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-menghapus-teks-tertentu-dari-sel\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/\",\"name\":\"Excel: Cara menghapus teks tertentu dari sel - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:18:28+00:00\",\"dateModified\":\"2023-07-20T22:18:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus teks tertentu dari sel di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghapus teks tertentu dari 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 menghapus teks tertentu dari sel - Statorial","description":"Tutorial ini menjelaskan cara menghapus teks tertentu dari sel di Excel, dengan beberapa contoh.","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-menghapus-teks-tertentu-dari-sel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghapus teks tertentu dari sel - Statorial","og_description":"Tutorial ini menjelaskan cara menghapus teks tertentu dari sel di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:18:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/subst1.jpg"}],"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-menghapus-teks-tertentu-dari-sel\/","url":"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/","name":"Excel: Cara menghapus teks tertentu dari sel - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:18:28+00:00","dateModified":"2023-07-20T22:18:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus teks tertentu dari sel di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghapus teks tertentu dari 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\/2742"}],"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=2742"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2742\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}