{"id":3849,"date":"2023-07-15T04:41:46","date_gmt":"2023-07-15T04:41:46","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/"},"modified":"2023-07-15T04:41:46","modified_gmt":"2023-07-15T04:41:46","slug":"google-sheet-menghapus-karakter-non-numerik","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/","title":{"rendered":"Google spreadsheet: hapus karakter non-numerik dari sel"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk menghapus karakter non-numerik dari sel di Google Spreadsheet:<\/span><\/p>\n

 =REGEXREPLACE( A2<\/span> ,\" \\D+<\/span> \", \"\")\n<\/span><\/strong><\/pre>\n
 Rumus khusus ini akan menghapus semua karakter non-numerik dari sel A2<\/strong> .<\/span><\/p>\n
 Contoh: Hapus karakter non-numerik dari sel di Google Spreadsheet<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki daftar nomor telepon berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang misalkan kita ingin menghapus semua karakter non-numerik dari setiap nomor telepon sehingga hanya angkanya saja yang tersisa.<\/span><\/p>\n
 Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n
 =REGEXREPLACE( A2<\/span> ,\" \\D+<\/span> \", \"\")<\/span><\/strong><\/pre>\n
 Kita ketik rumus ini di sel B2<\/strong> , lalu seret dan isi setiap sel yang tersisa di kolom B:<\/span> <\/p>\n
\"Google<\/p>\n
 Perhatikan bahwa setiap karakter non-numerik telah dihapus dari setiap nomor telepon.<\/span><\/p>\n
 Secara khusus, tanda kurung dan tanda hubung telah dihapus dari setiap nomor telepon.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi REGEXREPLACE<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara mengekstrak substring di Google Sheets<\/a>
 Cara membalikkan string teks di Google Sheets<\/a>
 Cara mengekstrak angka dari string di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut untuk menghapus karakter non-numerik dari sel di Google Spreadsheet: =REGEXREPLACE( A2 ,” \\D+ “, “”) Rumus khusus ini akan menghapus semua karakter non-numerik dari sel A2 . Contoh: Hapus karakter non-numerik dari sel di Google Spreadsheet Katakanlah kita memiliki daftar nomor telepon berikut di Google Spreadsheet: Sekarang misalkan kita ingin […]<\/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":"\nGoogle Spreadsheet: Hapus karakter non-numerik dari sel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus karakter non-numerik dari sel di Google Sheets, 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\/google-sheet-menghapus-karakter-non-numerik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Hapus karakter non-numerik dari sel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus karakter non-numerik dari sel di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T04:41:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimernon1.jpg\" \/>\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\/google-sheet-menghapus-karakter-non-numerik\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/\",\"name\":\"Google Spreadsheet: Hapus karakter non-numerik dari sel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T04:41:46+00:00\",\"dateModified\":\"2023-07-15T04:41:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus karakter non-numerik dari sel di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: hapus karakter non-numerik dari sel\"}]},{\"@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":"Google Spreadsheet: Hapus karakter non-numerik dari sel - Statologi","description":"Tutorial ini menjelaskan cara menghapus karakter non-numerik dari sel di Google Sheets, 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\/google-sheet-menghapus-karakter-non-numerik\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Hapus karakter non-numerik dari sel - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus karakter non-numerik dari sel di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/","og_site_name":"Statorials","article_published_time":"2023-07-15T04:41:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimernon1.jpg"}],"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\/google-sheet-menghapus-karakter-non-numerik\/","url":"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/","name":"Google Spreadsheet: Hapus karakter non-numerik dari sel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T04:41:46+00:00","dateModified":"2023-07-15T04:41:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus karakter non-numerik dari sel di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-non-numerik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: hapus karakter non-numerik dari sel"}]},{"@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\/3849"}],"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=3849"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3849\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}