{"id":4906,"date":"2023-07-06T14:16:06","date_gmt":"2023-07-06T14:16:06","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/"},"modified":"2023-07-06T14:16:06","modified_gmt":"2023-07-06T14:16:06","slug":"excel-hapus-titik-koma","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/","title":{"rendered":"Cara menghapus titik koma dari sel di excel"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk menghapus titik koma dari teks di sel di Excel:<\/span><\/p>\n

 =SUBSTITUTE( A2<\/span> , \";\", \"\")\n<\/strong><\/pre>\n
 Rumus khusus ini menghapus semua titik koma dari teks di sel A2<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Cara menghapus titik koma dari sel di Excel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar nilai teks berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita ingin menghapus titik koma dari teks di setiap sel di kolom A.<\/span><\/p>\n
 Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel B2<\/strong> :<\/span><\/p>\n
 =SUBSTITUTE( A2<\/span> , \";\", \"\")<\/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
 Kolom B menampilkan setiap nilai teks di kolom A dengan titik koma dihilangkan.<\/span><\/p>\n
 Jika Anda ingin mengganti titik koma dengan nilai yang berbeda, Anda dapat menentukan nilai tersebut dalam fungsi SUBSTITUTE<\/strong> .<\/span><\/p>\n
 Misalnya, Anda bisa menggunakan rumus berikut untuk mengganti setiap titik koma dengan spasi:<\/span><\/p>\n
 =SUBSTITUTE( A2<\/span> , \";\", \" \")<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom B menampilkan setiap nilai teks di kolom A dengan titik koma diganti dengan spasi.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi SUBSTITUTE<\/strong> di Excel di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: cara memeriksa apakah sel berisi sebagian teks<\/a>
 Excel: cara memeriksa apakah sel berisi teks daftar<\/a>
 Excel: cara menghitung frekuensi teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut untuk menghapus titik koma dari teks di sel di Excel: =SUBSTITUTE( A2 , “;”, “”) Rumus khusus ini menghapus semua titik koma dari teks di sel A2 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Cara menghapus titik koma dari sel di Excel Misalkan kita memiliki daftar […]<\/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 Titik Koma dari Sel di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghilangkan titik koma dari teks di sel Excel, beserta contohnya.\" \/>\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-titik-koma\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Titik Koma dari Sel di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghilangkan titik koma dari teks di sel Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T14:16:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semi1.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-titik-koma\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/\",\"name\":\"Cara Menghapus Titik Koma dari Sel di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T14:16:06+00:00\",\"dateModified\":\"2023-07-06T14:16:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghilangkan titik koma dari teks di sel Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus titik koma dari sel 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 Titik Koma dari Sel di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghilangkan titik koma dari teks di sel Excel, beserta contohnya.","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-titik-koma\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Titik Koma dari Sel di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghilangkan titik koma dari teks di sel Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/","og_site_name":"Statorials","article_published_time":"2023-07-06T14:16:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semi1.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-titik-koma\/","url":"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/","name":"Cara Menghapus Titik Koma dari Sel di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T14:16:06+00:00","dateModified":"2023-07-06T14:16:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghilangkan titik koma dari teks di sel Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hapus-titik-koma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus titik koma dari sel 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\/4906"}],"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=4906"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4906\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}