{"id":4921,"date":"2023-07-06T09:36:58","date_gmt":"2023-07-06T09:36:58","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/"},"modified":"2023-07-06T09:36:58","modified_gmt":"2023-07-06T09:36:58","slug":"excel-hapus-tanda-kurung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/","title":{"rendered":"Cara menghapus tanda kurung di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghapus tanda kurung dari teks di sel tertentu di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"(\", \"\"), \")\", \"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghapus semua tanda kurung dari teks di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Menghilangkan Tanda Kurung di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38416 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rem1.png\" alt=\"\" width=\"502\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghapus semua tanda kurung dari setiap sel di kolom Posisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"(\", \"\"), \")\", \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38417\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rem2.png\" alt=\"Excel menghapus tanda kurung\" width=\"585\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom C sekarang menampilkan teks di setiap sel yang cocok di kolom A dengan tanda kurung dihapus.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bagaimana cara kerja rumus ini?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ingat rumus yang kita gunakan untuk menghilangkan tanda kurung pada teks di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"(\", \"\"), \")\", \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Begini cara kerja rumus ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>SUBSTITUTE<\/strong> di Excel menggantikan semua kemunculan pola tertentu dengan pola lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>SUBSTITUTE<\/strong> internal dalam rumus menggantikan semua tanda kurung kiri <strong>(<\/strong> dengan spasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian fungsi <strong>SUBSTITUTE<\/strong> bagian luar menggantikan semua tanda kurung di sebelah kanan <strong>)<\/strong> dengan spasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah semua tanda kurung di sel <strong>A2<\/strong> diganti dengan spasi, sama saja dengan menghilangkan seluruh tanda kurung.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><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\/menghitung-frekuensi-teks-di-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung frekuensi teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghapus tanda kurung dari teks di sel tertentu di Excel: =SUBSTITUTE(SUBSTITUTE( A2 ,&#8221;(&#8220;, &#8220;&#8221;), &#8220;)&#8221;, &#8220;&#8221;) Rumus khusus ini menghapus semua tanda kurung dari teks di sel A2 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Cara Menghilangkan Tanda Kurung di Excel Katakanlah kita memiliki kumpulan [&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>Cara Menghapus Tanda Kurung di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghilangkan tanda kurung 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-hapus-tanda-kurung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Tanda Kurung di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghilangkan tanda kurung di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T09:36:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rem1.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-hapus-tanda-kurung\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/\",\"name\":\"Cara Menghapus Tanda Kurung di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T09:36:58+00:00\",\"dateModified\":\"2023-07-06T09:36:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghilangkan tanda kurung di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus tanda kurung di excel (dengan contoh)\"}]},{\"@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 Tanda Kurung di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghilangkan tanda kurung 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-hapus-tanda-kurung\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Tanda Kurung di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghilangkan tanda kurung di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/","og_site_name":"Statorials","article_published_time":"2023-07-06T09:36:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rem1.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-hapus-tanda-kurung\/","url":"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/","name":"Cara Menghapus Tanda Kurung di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T09:36:58+00:00","dateModified":"2023-07-06T09:36:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghilangkan tanda kurung di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hapus-tanda-kurung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus tanda kurung di excel (dengan contoh)"}]},{"@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\/4921"}],"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=4921"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4921\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}