{"id":1753,"date":"2023-11-07T02:05:28","date_gmt":"2023-11-07T02:05:28","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/"},"modified":"2023-12-06T06:19:17","modified_gmt":"2023-12-06T06:19:17","slug":"menghapus-karakter-yang-tidak-diinginkan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/","title":{"rendered":"Bagaimana cara menghapus karakter yang tidak diinginkan di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2559921751\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, saat bekerja dengan data, Anda mungkin harus berurusan dengan karakter yang tidak Anda inginkan. Dalam hal ini, Anda dapat menulis rumus menggunakan SUBSTITUTE yang dapat menghilangkan karakter yang tidak diinginkan tersebut. Dan dalam tutorial ini, kita akan mempelajari cara menulis rumus ini.<\/p><h2 class=\"wp-block-heading\"> Formula untuk menghapus karakter yang tidak diinginkan<\/h2><p> Ikuti langkah-langkah berikut untuk menulis rumus ini:<\/p><ol type=\"1\"><li> Pertama, di dalam sel, masukkan fungsi REPLACE.<\/li><li> Selanjutnya, rujuk ke sel tempat teks asli berada.<\/li><li> Setelah itu masukkan karakter yang ingin dihilangkan (gunakan tanda kutip ganda).<\/li><li> Sekarang masukkan karakter kosong menggunakan tanda kutip ganda.<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13492\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\" alt=\"menghapus karakter yang tidak diinginkan\" width=\"500\" height=\"183\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png 500w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable-300x110.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(A1,\"@\",\" \")<\/code><\/pre><p> Rumus ini menghilangkan karakter &#8220;@&#8221; dari nilai di sel A1 dan menggantinya dengan tanpa karakter. Daripada menggantinya dengan apa pun, Anda juga bisa memanfaatkan ruang kosong.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(A1,\"@\",\"\")<\/code><\/pre><p> Menggunakan fungsi SUBSTITUTE adalah cara tercepat untuk menghapus karakter yang tidak diinginkan dari sebuah string. Dan jika Anda ingin menghapus dua karakter atau lebih dari satu sel, Anda perlu menggunakan fungsi REPLACE dua kali. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13490\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-plusieurs-caracteres-indesirable.png\" alt=\"hapus-beberapa-karakter-sampah\" width=\"500\" height=\"220\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-plusieurs-caracteres-indesirable.png 500w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-plusieurs-caracteres-indesirable-300x132.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\"><\/figure><\/div><p> Pada contoh di atas Anda memiliki tiga karakter berbeda yang tidak ingin kita miliki dalam string teks. Jadi sekarang Anda perlu menggunakan SUBSTITUTE bersarang untuk menghilangkan karakter-karakter ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,\"@\",\"\"),\"!\",\"\"),\"-\",\"\")<\/code><\/pre><p> Anda memiliki tiga fungsi SUBSTITUTE; rumusnya menghapus karakter yang tidak diinginkan pada setiap fungsi. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/caracteres-indesirables.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> Hapus karakter pertama dari sel di Excel<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-spasi-tambahan\/\">Hapus spasi ekstra di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mendapatkan-kata-pertama-dan-terakhir\/\">Pisahkan Nama di Excel \u2013 (Nama Depan dan Belakang)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ekstrak-kata-terakhir-2\/\">Ekstrak kata terakhir dari sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-jeda-baris-2\/\">Hapus jeda baris dari sel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1753","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hapus karakter yang tidak diinginkan di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghapus karakter yang tidak diinginkan. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hapus karakter yang tidak diinginkan di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghapus karakter yang tidak diinginkan. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/\",\"name\":\"Hapus karakter yang tidak diinginkan di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\",\"datePublished\":\"2023-11-07T02:05:28+00:00\",\"dateModified\":\"2023-12-06T06:19:17+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghapus karakter yang tidak diinginkan. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus karakter yang tidak diinginkan di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hapus karakter yang tidak diinginkan di Excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghapus karakter yang tidak diinginkan. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/","og_locale":"id_ID","og_type":"article","og_title":"Hapus karakter yang tidak diinginkan di Excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghapus karakter yang tidak diinginkan. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/","url":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/","name":"Hapus karakter yang tidak diinginkan di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png","datePublished":"2023-11-07T02:05:28+00:00","dateModified":"2023-12-06T06:19:17+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghapus karakter yang tidak diinginkan. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/supprimer-le-caractere-indesirable.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghapus-karakter-yang-tidak-diinginkan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus karakter yang tidak diinginkan di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1753"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1753\/revisions"}],"predecessor-version":[{"id":2834,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1753\/revisions\/2834"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}