{"id":3848,"date":"2023-07-15T04:50:40","date_gmt":"2023-07-15T04:50:40","guid":{"rendered":"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/"},"modified":"2023-07-15T04:50:40","modified_gmt":"2023-07-15T04:50:40","slug":"hapus-lembar-google-di-bawah-string","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/","title":{"rendered":"Cara menghapus substring di google sheets (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk menghapus substring tertentu dari sel di Google Spreadsheet:<\/span><\/p>\n

Metode 1: Hapus substring dari sel<\/strong><\/span><\/p>\n

 =<\/span> SUBSTITUTE<\/span> (<\/span> A2<\/span> ,<\/span> \" this_string<\/span> \"<\/span> ,<\/span> \"\"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Metode 2: Hapus Beberapa Substring dari Sel<\/strong><\/span><\/p>\n
 =<\/span> SUBSTITUTE<\/span> (<\/span> SUBSTITUTE<\/span> (<\/span> A2<\/span> ,<\/span> \" string1<\/span> \"<\/span> ,<\/span> \"\"<\/span> )<\/span> ,<\/span> \" string2<\/span> \"<\/span> ,<\/span> \"\"<\/span> )<\/span><\/strong>\n<\/pre>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/p>\n
 Catatan<\/strong> : Rumus ini \u201cmenghapus\u201d substring dari sel dengan mengganti substring tertentu dengan spasi.<\/span><\/p>\n
 Metode 1: Hapus substring dari sel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang berbagai tim bola basket:<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk menghapus substring “Tim” dari setiap sel di kolom A:<\/span><\/p>\n
 =<\/span> SUBSTITUTE<\/span> (<\/span> A2<\/span> ,<\/span> \" Team<\/span> \"<\/span> ,<\/span> \"\"<\/span> )<\/span><\/strong><\/pre>\n
 Kami akan mengetikkan rumus ini di sel C2<\/strong> , menyeretnya, dan mengisinya di setiap sel yang tersisa di kolom C:<\/span> <\/p>\n
\"Google<\/p>\n
 Perhatikan bahwa substring “Tim” telah dihapus dari setiap sel.<\/span><\/p>\n
 Metode 2: Hapus Beberapa Substring dari Sel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk menghapus substring “Tim” dan “Nama” dari setiap sel di kolom A:<\/span><\/p>\n
 =<\/span> SUBSTITUTE<\/span> (<\/span> SUBSTITUTE<\/span> (<\/span> A2<\/span> ,<\/span> \" Team<\/span> \"<\/span> ,<\/span> \"\"<\/span> )<\/span> ,<\/span> \" Name<\/span> \"<\/span> ,<\/span> \"\"<\/span> )<\/span><\/strong><\/pre>\n
 Kami akan mengetikkan rumus ini di sel C2<\/strong> , menyeretnya, dan mengisinya di setiap sel yang tersisa di kolom C:<\/span> <\/p>\n
\"Google<\/p>\n
 Perhatikan bahwa substring “Tim” dan “Nama” telah dihapus dari setiap sel.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menggunakan fungsi SUBSTITUTE<\/strong> bertingkat sebanyak yang Anda inginkan untuk menghapus substring dari sel sebanyak yang Anda inginkan.<\/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 substring tertentu dari sel di Google Spreadsheet: Metode 1: Hapus substring dari sel = SUBSTITUTE ( A2 , ” this_string ” , “” ) Metode 2: Hapus Beberapa Substring dari Sel = SUBSTITUTE ( SUBSTITUTE ( A2 , ” string1 ” , “” ) , ” string2 ” […]<\/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 Substring di Google Sheets (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus substring dari sel di Google Sheets, dengan 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\/hapus-lembar-google-di-bawah-string\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Substring di Google Sheets (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus substring dari sel di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T04:50:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous-marins1.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\/hapus-lembar-google-di-bawah-string\/\",\"url\":\"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/\",\"name\":\"Cara Menghapus Substring di Google Sheets (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T04:50:40+00:00\",\"dateModified\":\"2023-07-15T04:50:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus substring dari sel di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus substring di google sheets (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 Substring di Google Sheets (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghapus substring dari sel di Google Sheets, dengan 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\/hapus-lembar-google-di-bawah-string\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Substring di Google Sheets (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghapus substring dari sel di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/","og_site_name":"Statorials","article_published_time":"2023-07-15T04:50:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous-marins1.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\/hapus-lembar-google-di-bawah-string\/","url":"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/","name":"Cara Menghapus Substring di Google Sheets (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T04:50:40+00:00","dateModified":"2023-07-15T04:50:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus substring dari sel di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus substring di google sheets (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\/3848"}],"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=3848"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3848\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}