{"id":5082,"date":"2023-07-04T00:26:03","date_gmt":"2023-07-04T00:26:03","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/"},"modified":"2023-07-04T00:26:03","modified_gmt":"2023-07-04T00:26:03","slug":"excel-menghapus-tanda-kutip","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/","title":{"rendered":"Cara menghapus kutipan di excel (2 metode)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada dua cara umum untuk menghapus tanda kutip dari sel di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan Temukan dan Ganti<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan fungsi SUBSTITUTE<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan daftar nama tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39599 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rq1.png\" alt=\"\" width=\"453\" height=\"384\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hapus tanda kutip menggunakan Temukan dan Ganti<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pertama, sorot rentang sel <strong>A2:A11<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kemudian ketik <strong>Ctrl + H<\/strong> untuk menampilkan fungsionalitas <strong>Temukan dan Ganti<\/strong> di Excel:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39600 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rq2.png\" alt=\"\" width=\"590\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketik <strong>\u201c<\/strong> di kotak <strong>Temukan<\/strong> dan biarkan kotak <strong>Ganti dengan<\/strong> kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Ganti Semua<\/strong> , tanda kutip di setiap sel akan dihapus dan kotak pesan akan muncul memberitahu Anda berapa banyak penggantian yang telah dilakukan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39601\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rq3.png\" alt=\"Excel menghapus tanda kutip menggunakan Temukan dan Ganti\" width=\"598\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tanda kutip di setiap nama tim telah dihapus.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hapus tanda kutip menggunakan fungsi SUBSTITUTE<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Cara lain untuk menghilangkan tanda kutip dari string di Excel adalah dengan menggunakan fungsi <strong>SUBSTITUTE<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghilangkan tanda kutip dari sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> , CHAR(34), )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39602\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rq4.png\" alt=\"Excel menghapus tanda kutip dari sel menggunakan fungsi SUBSTITUTE\" width=\"487\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B mengembalikan nama masing-masing tim dari sel terkait di kolom A dengan tanda kutip dihapus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>CHAR(34)<\/strong> adalah kode karakter untuk tanda kutip ganda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Menggunakan fungsi <strong>SUBSTITUTE<\/strong> , kami mengganti setiap kemunculan tanda kutip ganda di sel dengan apa pun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memiliki efek yang sama seperti menghapus semua tanda kutip dari setiap sel.<\/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-menambahkan-tanda-kutip-tunggal\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menambahkan Kutipan Tunggal ke Teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-sebelum-karakter\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengekstrak teks sebelum karakter<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengekstrak teks setelah karakter<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menghapus Teks Tertentu dari Sel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada dua cara umum untuk menghapus tanda kutip dari sel di Excel: Metode 1: Gunakan Temukan dan Ganti Metode 2: Gunakan fungsi SUBSTITUTE Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan daftar nama tim bola basket berikut di Excel: Ayo pergi! Contoh 1: Hapus tanda kutip menggunakan Temukan dan Ganti Pertama, sorot rentang [&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 Kutipan di Excel (2 Metode) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus tanda kutip 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-tanda-kutip\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Kutipan di Excel (2 Metode) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus tanda kutip dari sel di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T00:26:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rq1.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-tanda-kutip\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/\",\"name\":\"Cara Menghapus Kutipan di Excel (2 Metode) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T00:26:03+00:00\",\"dateModified\":\"2023-07-04T00:26:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus tanda kutip dari sel di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus kutipan di excel (2 metode)\"}]},{\"@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 Kutipan di Excel (2 Metode) - Statologi","description":"Tutorial ini menjelaskan cara menghapus tanda kutip 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-tanda-kutip\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Kutipan di Excel (2 Metode) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus tanda kutip dari sel di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/","og_site_name":"Statorials","article_published_time":"2023-07-04T00:26:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rq1.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-tanda-kutip\/","url":"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/","name":"Cara Menghapus Kutipan di Excel (2 Metode) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T00:26:03+00:00","dateModified":"2023-07-04T00:26:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus tanda kutip dari sel di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghapus-tanda-kutip\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus kutipan di excel (2 metode)"}]},{"@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\/5082"}],"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=5082"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5082\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}