{"id":4678,"date":"2023-07-09T01:08:06","date_gmt":"2023-07-09T01:08:06","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/"},"modified":"2023-07-09T01:08:06","modified_gmt":"2023-07-09T01:08:06","slug":"google-sheet-menyisakan-ruang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/","title":{"rendered":"Google spreadsheet: gunakan kiri untuk mengekstrak teks sebelum spasi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut dengan fungsi <strong>LEFT<\/strong> dan <strong>FIND<\/strong> untuk mengekstrak semua teks sebelum ditemukan spasi di sel Google Sheets:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #ff6600;\">A2<\/span> , FIND(\" \", <span style=\"color: #ff6600;\">A2<\/span> ) <span style=\"color: #3366ff;\">-1<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengekstrak semua teks dari sel <strong>A2<\/strong> yang muncul sebelum spasi pertama ditemukan.<\/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: Menggunakan LEFT untuk mengekstrak teks sebelum spasi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar berikut di Google Spreadsheet yang memberikan deskripsi singkat tentang berbagai pemain bola basket, termasuk tim, posisi, dan peringkatnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36529 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauches1.png\" alt=\"\" width=\"512\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita hanya ingin mengekstrak nama tim untuk setiap pemain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menggunakan rumus berikut dengan fungsi <strong>LEFT<\/strong> dan <strong>FIND<\/strong> Google Sheets untuk mengekstrak teks dari sisi kiri setiap sel hingga ditemukan spasi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #ff6600;\">A2<\/span> , FIND(\" \", <span style=\"color: #ff6600;\">A2<\/span> ) <span style=\"color: #3366ff;\">-1<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu klik dan seret rumus ini ke setiap sel tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36530\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauches2.png\" alt=\"Google Sheets mengekstrak teks yang tersisa dari luar angkasa\" width=\"468\" height=\"453\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B kini hanya menampilkan nama tim masing-masing pemain di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Harap dicatat bahwa jika tidak ada spasi yang ditemukan di kolom Deskripsi Pemain, rumus akan mengembalikan <strong>#VALUE!<\/strong> Karena itu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengembalikan nilai yang berbeda, cukup gunakan fungsi <strong>IFERROR()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan fungsi <strong>IFERROR()<\/strong> berikut untuk mengembalikan &#8220;Tidak ada spasi&#8221; jika spasi tidak ditemukan dalam deskripsi pemain tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR(LEFT( <span style=\"color: #ff6600;\">A2<\/span> , FIND(\" \", <span style=\"color: #ff6600;\">A2<\/span> )- <span style=\"color: #3366ff;\">1<\/span> ), \" <span style=\"color: #008000;\">No space<\/span> \")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36531 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauches3.png\" alt=\"\" width=\"524\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat mengembalikan nilai yang berbeda hanya dengan mengganti &#8220;Tanpa spasi&#8221; dengan nilai lain di fungsi <strong>IFERROR()<\/strong> .<\/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> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut dengan fungsi LEFT dan FIND untuk mengekstrak semua teks sebelum ditemukan spasi di sel Google Sheets: =LEFT( A2 , FIND(&#8221; &#8220;, A2 ) -1 ) Rumus khusus ini mengekstrak semua teks dari sel A2 yang muncul sebelum spasi pertama ditemukan. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: [&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: Gunakan KIRI untuk mengekstrak teks sebelum spasi - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak teks di sebelah kiri spasi di Google Sheets, 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\/google-sheet-menyisakan-ruang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Gunakan KIRI untuk mengekstrak teks sebelum spasi - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak teks di sebelah kiri spasi di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T01:08:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauches1.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-menyisakan-ruang\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/\",\"name\":\"Google Spreadsheet: Gunakan KIRI untuk mengekstrak teks sebelum spasi - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T01:08:06+00:00\",\"dateModified\":\"2023-07-09T01:08:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak teks di sebelah kiri spasi di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: gunakan kiri untuk mengekstrak teks sebelum spasi\"}]},{\"@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: Gunakan KIRI untuk mengekstrak teks sebelum spasi - Statorial","description":"Tutorial ini menjelaskan cara mengekstrak teks di sebelah kiri spasi di Google Sheets, 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\/google-sheet-menyisakan-ruang\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Gunakan KIRI untuk mengekstrak teks sebelum spasi - Statorial","og_description":"Tutorial ini menjelaskan cara mengekstrak teks di sebelah kiri spasi di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/","og_site_name":"Statorials","article_published_time":"2023-07-09T01:08:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauches1.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-menyisakan-ruang\/","url":"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/","name":"Google Spreadsheet: Gunakan KIRI untuk mengekstrak teks sebelum spasi - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T01:08:06+00:00","dateModified":"2023-07-09T01:08:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak teks di sebelah kiri spasi di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menyisakan-ruang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: gunakan kiri untuk mengekstrak teks sebelum spasi"}]},{"@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\/4678"}],"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=4678"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4678\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}