{"id":1917,"date":"2023-10-28T03:16:17","date_gmt":"2023-10-28T03:16:17","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/"},"modified":"2023-12-06T06:19:30","modified_gmt":"2023-12-06T06:19:30","slug":"hapus-tanda-hubung","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/","title":{"rendered":"Bagaimana cara menghapus tanda hubung di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2388154139\"><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>Ada beberapa bentuk data yang mungkin memiliki tanda hubung di antaranya. Misalnya nomor SNN, tanggal dan nomor ponsel. Sekarang di Excel ada beberapa cara dengan rumus yang bisa Anda gunakan untuk menghilangkan tanda hubung dari nilai-nilai ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77759\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus tanda hubung\" width=\"387\" height=\"362\"><\/figure><\/div><p> Dalam tutorial ini, kita akan melihat berbagai metode yang dapat kita gunakan untuk menghapus tanda hubung dari nilai di Excel.<\/p><h2 class=\"wp-block-heading\"> Hapus Tanda Hubung dari SSN (Nomor Jaminan Sosial)<\/h2><ol type=\"1\"><li> Pertama, di sel B2, masukkan <strong>\u201cSUBSTITUTE(\u201c.<\/strong><\/li><li> Setelah itu, di argumen pertama, rujuk ke sel tempat Anda memiliki SSN.<\/li><li> Selanjutnya, masukkan tanda hubung menggunakan tanda kutip ganda.<\/li><li> Sekarang untuk argumen ketiga, masukkan nilai kosong menggunakan tanda kutip ganda.<\/li><li> Terakhir, masukkan tanda kurung penutup dan 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=\"wp-image-77760\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-supprimer-les-tirets-par-substitution.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus tanda hubung dengan substitusi\" width=\"491\" height=\"279\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBSTITUTE(A1,\"-\",\"\")<\/code><\/pre><p> Setelah Anda memasukkan rumus, Anda akan mendapatkan nilai tanpa tanda hubung di sel<\/p><p> Namun saya sarankan Anda menerapkan format SSN setiap kali Anda memasukkan SSN di Excel. Ini tidak akan menambahkan tanda hubung ke nilai tetapi ini adalah format yang diberi tanda hubung.<\/p><p> Pilihan Format Sel \u21e2 Angka \u21e2 Khusus \u21e2 Nomor Jaminan Sosial. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77761\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Option-speciale-de-la-boite-de-dialogue-Format-3-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"format-sel-kotak dialog-opsi-khusus\" width=\"525\" height=\"520\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan Temukan dan Ganti untuk Menghapus Tanda Hubung di Excel<\/h2><ol type=\"1\"><li> Pertama, pilih rentang sel yang ingin Anda hapus tanda hubungnya.<\/li><li> Selanjutnya, buka opsi <a href=\"https:\/\/exceladvisor.org\/id\/temukan-penggantinya\/\">Temukan dan Ganti<\/a> menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/temukan-pengganti-1\/\">pintasan keyboard Ctrl + H.<\/a><\/li><li> Setelah itu, masukkan tanda hubung di kolom Pencarian.<\/li><li> Sekarang di tempat dengan, jangan masukkan apa pun.<\/li><li> Pada akhirnya, klik Ganti Semua. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77762\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-rechercher-et-remplacer-pour-supprimer-les-tirets.png\" sizes=\"auto, \" srcset=\"\" alt=\"temukan dan ganti untuk menghapus tanda hubung\" width=\"681\" height=\"299\"><\/figure><\/div><p> Saat Anda mengklik tombol \u201cGanti Semua\u201d, itu akan menggantikan tanda hubung dari semua sel yang dipilih. Dan jika Anda tidak memilih sel apa pun, tanda hubung akan dihapus dari seluruh lembar kerja. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77763\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-remplacer-tout.png\" sizes=\"auto, \" srcset=\"\" alt=\"ganti semuanya\" width=\"692\" height=\"255\"><\/figure><\/div><p> Klik tombol Opsi dan pilih buku kerja dari menu tarik-turun &#8220;Dalam&#8221; untuk menghapus garis putus-putus dari keseluruhan buku kerja.<\/p><h2 class=\"wp-block-heading\"> Gunakan kode VBA untuk menghapus semua tanda hubung<\/h2><p> Anda juga dapat menjalankan kode VBA untuk menghapus tanda hubung dari sel yang dipilih. Di bawah ini Anda memiliki kode yang dapat Anda gunakan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub remove_dashes() Dim iCell As <strong>Range<\/strong> <strong>For<\/strong> Each iCell <strong>In<\/strong> <strong>Selection<\/strong> . <strong>Cells<\/strong>   iCell. <strong>Value<\/strong> = <strong>Replace<\/strong> (iCell, \"-\", \"\") <strong>Next<\/strong> iCell <strong>End<\/strong> Sub<\/code><\/pre><p> Untuk menggunakan kode ini: Pilih rentang sel atau satu sel dan jalankan kode.<\/p><p> Namun jika Anda ingin menghapus tanda hubung dan menerapkan format nomor jaminan sosial ke sel yang dipilih, Anda dapat menggunakan kode di bawah ini daripada kode di atas.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub remove_dashes() Dim iCell As <strong>Range<\/strong> <strong>For<\/strong> Each iCell <strong>In<\/strong> <strong>Selection<\/strong> . <strong>Cells<\/strong>   iCell. <strong>Value<\/strong> = <strong>Replace<\/strong> (iCell, \"-\", \"\")   iCell. <strong>NumberFormat<\/strong> = \"000-00-0000\" <strong>Next<\/strong> iCell <strong>End<\/strong> Sub<\/code><\/pre><p> Ini akan menghapus tanda hubung dari nomor tersebut tetapi juga akan menerapkan format SSN ke nilainya, seperti yang Anda lihat dalam contoh berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77764\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-supprimer-le-tableau-de-bord-a-laide-de-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus-dasbor-menggunakan-vba\" width=\"453\" height=\"358\"><\/figure><\/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\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/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> <a href=\"https:\/\/exceladvisor.org\/id\/alat-analisis-cepat\/\">Alat Analisis Cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\">Terapkan beberapa filter ke kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\">Sorot nilai N atas dan bawah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-centang\/\">Sisipkan kotak centang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-tanpa-kehilangan-data\/\">Gabungkan sel tanpa kehilangan data di Excel<\/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-1917","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>Bagaimana cara menghapus tanda hubung di Excel? (Panduan 2023)<\/title>\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\/hapus-tanda-hubung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghapus tanda hubung di Excel? (Panduan 2023)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/\",\"name\":\"Bagaimana cara menghapus tanda hubung di Excel? (Panduan 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png\",\"datePublished\":\"2023-10-28T03:16:17+00:00\",\"dateModified\":\"2023-12-06T06:19:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus tanda hubung 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":"Bagaimana cara menghapus tanda hubung di Excel? (Panduan 2023)","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\/hapus-tanda-hubung\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghapus tanda hubung di Excel? (Panduan 2023)","og_url":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/","url":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/","name":"Bagaimana cara menghapus tanda hubung di Excel? (Panduan 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png","datePublished":"2023-10-28T03:16:17+00:00","dateModified":"2023-12-06T06:19:30+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-tirets.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hapus-tanda-hubung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus tanda hubung 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\/1917","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=1917"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1917\/revisions"}],"predecessor-version":[{"id":2860,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1917\/revisions\/2860"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}