{"id":5084,"date":"2023-07-03T23:51:11","date_gmt":"2023-07-03T23:51:11","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/"},"modified":"2023-07-03T23:51:11","modified_gmt":"2023-07-03T23:51:11","slug":"google-sheet-mengekstrak-teks-sebelum-karakter","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/","title":{"rendered":"Google sheets: cara mengekstrak teks sebelum karakter"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk mengekstrak semua teks sebelum karakter tertentu dalam sel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">REGEXEXTRACT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">(.*)our.*<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengekstrak semua teks dari sel <strong>A2<\/strong> yang muncul sebelum string &#8220;kami&#8221; ditemukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini menggunakan fungsi <strong>REGEXTRACT<\/strong> untuk mengekstrak semua karakter <strong>(.*)<\/strong> <strong>sebelum<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Ekstrak teks sebelum karakter di Google Sheets<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar ekspresi berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39608 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/saf1.png\" alt=\"\" width=\"504\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mengekstrak semua teks dari setiap sel sebelum menemukan string &#8220;milik kita&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">REGEXEXTRACT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">(.*)our.*<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/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-39614\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbf1.png\" alt=\"Google Sheets mengekstrak teks sebelum karakter\" width=\"530\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan semua teks sebelum &#8220;kami&#8221; untuk setiap kalimat di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengekstrak teks sebelum karakter tertentu yang berbeda, cukup ganti <strong>karakter kami<\/strong> dengan yang lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengekstrak semua teks sebelum &#8220;is&#8221; dari sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">REGEXEXTRACT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">(.*)is.*<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/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=\" wp-image-39615 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbf2.png\" alt=\"\" width=\"521\" height=\"363\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan semua teks sebelum &#8220;adalah&#8221; untuk setiap kalimat di kolom A.<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-demi-karakter\/\">Google Sheets: Cara mengekstrak teks setelah karakter<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Periksa apakah sel berisi teks daftar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hitungan-lembar-google-jika-tidak-sama-dengan-teks\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: COUNTIF tidak sama dengan teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk mengekstrak semua teks sebelum karakter tertentu dalam sel: = REGEXEXTRACT ( A2 , &#8221; (.*)our.* &#8221; ) Rumus khusus ini mengekstrak semua teks dari sel A2 yang muncul sebelum string &#8220;kami&#8221; ditemukan. Rumus ini menggunakan fungsi REGEXTRACT untuk mengekstrak semua karakter (.*) sebelum . Contoh berikut [&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>Google Spreadsheet: Cara mengekstrak teks sebelum karakter - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak teks dari string di Excel sebelum karakter tertentu, dengan 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-mengekstrak-teks-sebelum-karakter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengekstrak teks sebelum karakter - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak teks dari string di Excel sebelum karakter tertentu, dengan contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T23:51:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/saf1.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-sheet-mengekstrak-teks-sebelum-karakter\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/\",\"name\":\"Google Spreadsheet: Cara mengekstrak teks sebelum karakter - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T23:51:11+00:00\",\"dateModified\":\"2023-07-03T23:51:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak teks dari string di Excel sebelum karakter tertentu, dengan contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengekstrak teks sebelum karakter\"}]},{\"@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: Cara mengekstrak teks sebelum karakter - Statologi","description":"Tutorial ini menjelaskan cara mengekstrak teks dari string di Excel sebelum karakter tertentu, dengan 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-mengekstrak-teks-sebelum-karakter\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengekstrak teks sebelum karakter - Statologi","og_description":"Tutorial ini menjelaskan cara mengekstrak teks dari string di Excel sebelum karakter tertentu, dengan contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/","og_site_name":"Statorials","article_published_time":"2023-07-03T23:51:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/saf1.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-sheet-mengekstrak-teks-sebelum-karakter\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/","name":"Google Spreadsheet: Cara mengekstrak teks sebelum karakter - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T23:51:11+00:00","dateModified":"2023-07-03T23:51:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak teks dari string di Excel sebelum karakter tertentu, dengan contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-sebelum-karakter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengekstrak teks sebelum karakter"}]},{"@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\/5084"}],"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=5084"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5084\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}