{"id":4685,"date":"2023-07-08T23:39:17","date_gmt":"2023-07-08T23:39:17","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/"},"modified":"2023-07-08T23:39:17","modified_gmt":"2023-07-08T23:39:17","slug":"excel-menghapus-karakter-khusus","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/","title":{"rendered":"Cara menghapus karakter khusus di excel"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk menghapus karakter khusus dari sel di Excel:<\/span><\/p>\n

 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( A2<\/span> ,\"!\",\"\"),\"@\",\"\"),\"#\",\"\"), \"$\" , \"\"), \"%\", \"\"), \"^\", \"\"), \"&\", \"\"), \"*\", \"\"), \"(\", \"\"), \")\", \" \")\n<\/strong><\/pre>\n
 Rumus khusus ini menghapus semua karakter khusus dari sel A2<\/strong> .<\/span><\/p>\n
 Rumus ini bekerja dengan menggunakan fungsi SUBSTITUTE<\/strong> bertingkat untuk mengganti karakter khusus tertentu dengan spasi, yang memiliki efek menghilangkan karakter khusus dari sel.<\/span><\/span><\/p>\n
 Catatan<\/strong> : Jika Anda ingin menghapus karakter khusus tambahan dari sel, cukup gunakan fungsi SUBSTITUTE tambahan yang disarangkan.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Hapus Karakter Khusus di Excel<\/span><\/strong><\/h2>\n
 Misalkan kita memiliki daftar ekspresi berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita ingin menghilangkan karakter khusus dari setiap kalimat di kolom A.<\/span><\/p>\n
 Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel B2<\/strong> :<\/span><\/p>\n
 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( A2<\/span> ,\"!\",\"\"),\"@\",\"\"),\"#\",\"\"), \"$\" , \"\"), \"%\", \"\"), \"^\", \"\"), \"&\", \"\"), \"*\", \"\"), \"(\", \"\"), \")\", \" \")\n<\/strong><\/pre>\n
 Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n
\"Excel<\/p>\n
 Sel di kolom B berisi frasa dari setiap sel terkait di kolom A dengan karakter khusus dihapus.<\/span><\/span><\/p>\n
 Perhatikan bahwa Anda dapat dengan mudah mengubah rumus ini untuk menghapus hanya karakter khusus tertentu dari sel.<\/span><\/p>\n
 Misalnya, Anda dapat menggunakan rumus berikut untuk menghapus saja !<\/strong> , @<\/strong> dan #<\/strong> dari sel:<\/span><\/p>\n
 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( A2<\/span> ,\"!\",\"\"),\"@\",\"\"),\"#\",\"\")<\/strong><\/pre>\n
 Jangan ragu untuk mengedit rumus untuk menghapus karakter khusus yang Anda inginkan dari sel.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara menemukan tanda bintang di sel di Excel<\/a>
 Cara Menemukan Tanda Tanya di Excel<\/a>
 Cara Menemukan Karakter Khusus dalam Sel di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut untuk menghapus karakter khusus dari sel di Excel: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( A2 ,”!”,””),”@”,””),”#”,””), “$” , “”), “%”, “”), “^”, “”), “&”, “”), “*”, “”), “(“, “”), “)”, ” “) Rumus khusus ini menghapus semua karakter khusus dari sel A2 . Rumus ini bekerja dengan menggunakan fungsi SUBSTITUTE bertingkat untuk mengganti karakter khusus […]<\/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":"\nCara Menghapus Karakter Khusus di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus karakter khusus dari sel di Excel, beserta sebuah 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-karakter-khusus\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Karakter Khusus di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus karakter khusus dari sel di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T23:39:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rspecial1.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-menghapus-karakter-khusus\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/\",\"name\":\"Cara Menghapus Karakter Khusus di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T23:39:17+00:00\",\"dateModified\":\"2023-07-08T23:39:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus karakter khusus dari sel di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus karakter khusus di excel\"}]},{\"@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":"Cara Menghapus Karakter Khusus di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghapus karakter khusus dari sel di Excel, beserta sebuah 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-karakter-khusus\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Karakter Khusus di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghapus karakter khusus dari sel di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/","og_site_name":"Statorials","article_published_time":"2023-07-08T23:39:17+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rspecial1.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-menghapus-karakter-khusus\/","url":"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/","name":"Cara Menghapus Karakter Khusus di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T23:39:17+00:00","dateModified":"2023-07-08T23:39:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus karakter khusus dari sel di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus karakter khusus di excel"}]},{"@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\/4685"}],"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=4685"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4685\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}