{"id":2299,"date":"2023-07-22T21:22:03","date_gmt":"2023-07-22T21:22:03","guid":{"rendered":"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/"},"modified":"2023-07-22T21:22:03","modified_gmt":"2023-07-22T21:22:03","slug":"google-meninggalkan-rantai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/","title":{"rendered":"Cara mengekstrak substring di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mengekstrak substring tertentu dari teks di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Kembalikan substring dari awal string<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#return first 4 characters of string in cell A1<\/span>\n= <span style=\"color: #3366ff;\">LEFT<\/span> ( <span style=\"color: #ff6600;\">A1,4<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Kembalikan substring dari tengah string<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#return 4 characters of string in cell A1 starting at position 2<\/span>\n= <span style=\"color: #3366ff;\">MID<\/span> ( <span style=\"color: #ff6600;\">A1,2,4<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Kembalikan substring dari akhir string<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#return last 4 characters of string in cell A1<\/span>\n= <span style=\"color: #3366ff;\">RIGHT<\/span> ( <span style=\"color: #ff6600;\">A1,4<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 4: Kembalikan Substring Sebelum Beberapa Teks<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#return all text before the string \"there\" in cell A1<\/span>\n=LEFT( <span style=\"color: #ff6600;\">A1<\/span> , SEARCH(\" <span style=\"color: #008000;\">there<\/span> \", <span style=\"color: #ff6600;\">A1<\/span> )-1)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 5: Kembalikan substring setelah teks tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#return all text after the string \"there\" in cell A1<\/span>\n<span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">RIGHT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SEARCH<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">there<\/span> \u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)-1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: Kembalikan substring dari awal string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menggunakan fungsi <strong>LEFT()<\/strong> untuk mengembalikan tiga karakter pertama sel A2:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20905 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous1.png\" alt=\"\" width=\"497\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: Kembalikan substring dari tengah string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>MID()<\/strong> untuk mengembalikan lima karakter di tengah sel A2, dimulai dari posisi 4:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20906 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous2-1.png\" alt=\"\" width=\"490\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 3: Kembalikan substring dari akhir string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>RIGHT()<\/strong> untuk mengembalikan tiga karakter terakhir sel A2:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20907 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous3.png\" alt=\"\" width=\"493\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 4:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Kembalikan Substring Sebelum Beberapa Teks<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>LEFT()<\/strong> dan <strong>SEARCH()<\/strong> untuk mengembalikan semua teks sebelum string &#8220;di sana&#8221; di sel A2:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20908 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous4.png\" alt=\"\" width=\"507\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 5:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Kembalikan substring setelah teks tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>RIGHT()<\/strong> dan <strong>SEARCH()<\/strong> untuk mengembalikan semua teks yang muncul setelah string &#8220;di sana&#8221; di sel A2:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20909 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sub5.png\" alt=\"\" width=\"513\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara membulatkan ke angka penting di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sampel acak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara Menggabungkan Kolom di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mengekstrak substring tertentu dari teks di Google Spreadsheet: Metode 1: Kembalikan substring dari awal string #return first 4 characters of string in cell A1 = LEFT ( A1,4 ) Metode 2: Kembalikan substring dari tengah string #return 4 characters of string in cell A1 starting at position 2 = [&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 Mengekstrak Substring di Google Sheets (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak substring dari string di Google Sheets, 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\/google-meninggalkan-rantai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengekstrak Substring di Google Sheets (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak substring dari string di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T21:22:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous1.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\/google-meninggalkan-rantai\/\",\"url\":\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\",\"name\":\"Cara Mengekstrak Substring di Google Sheets (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T21:22:03+00:00\",\"dateModified\":\"2023-07-22T21:22:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak substring dari string di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengekstrak 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 Mengekstrak Substring di Google Sheets (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengekstrak substring dari string di Google Sheets, 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\/google-meninggalkan-rantai\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengekstrak Substring di Google Sheets (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengekstrak substring dari string di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/","og_site_name":"Statorials","article_published_time":"2023-07-22T21:22:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sous1.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\/google-meninggalkan-rantai\/","url":"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/","name":"Cara Mengekstrak Substring di Google Sheets (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T21:22:03+00:00","dateModified":"2023-07-22T21:22:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak substring dari string di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengekstrak 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\/2299"}],"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=2299"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2299\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}