{"id":5095,"date":"2023-07-03T18:15:16","date_gmt":"2023-07-03T18:15:16","guid":{"rendered":"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/"},"modified":"2023-07-03T18:15:16","modified_gmt":"2023-07-03T18:15:16","slug":"google-membiarkan-karakternya-terserah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/","title":{"rendered":"Google sheets: rumus kiri hingga karakter tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <b>LEFT<\/b> di Google Spreadsheet untuk mengekstrak sejumlah karakter dari sisi kiri string.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda bisa menggunakan rumus berikut untuk menggunakan fungsi <strong>LEFT<\/strong> untuk mengekstrak semua karakter dari sisi kiri string hingga karakter tertentu ditemukan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT(cell, FIND(\"specific_character\", cell)-1)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan rumus berikut untuk mengekstrak semua karakter dari sisi kiri string di sel <strong>A2<\/strong> hingga garis bawah ditemukan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #ff6600;\">A2<\/span> ,FIND(\" <span style=\"color: #008000;\">_<\/span> \", <span style=\"color: #ff6600;\">A2<\/span> ) <span style=\"color: #3366ff;\">-1<\/span> )<\/strong><\/pre>\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 hingga karakter tertentu di Google Sheets<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar nama tim bola basket berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39702 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gaucheu1.png\" alt=\"\" width=\"498\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengekstrak semua karakter dari nama tim di sel <strong>A2<\/strong> hingga ditemukan garis bawah:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #ff6600;\">A2<\/span> ,FIND(\" <span style=\"color: #008000;\">_<\/span> \", <span style=\"color: #ff6600;\">A2<\/span> ) <span style=\"color: #3366ff;\">-1<\/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-39704\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gaucheu2-1.png\" alt=\"Google Spreadsheet KIRI hingga karakter tertentu\" width=\"488\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan semua karakter di setiap nama tim hingga muncul garis bawah pada nama tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Harap dicatat bahwa jika tidak ditemukan garis bawah pada nama tim, 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 Ditemukan&#8221; jika tidak ada garis bawah yang ditemukan pada nama tim 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: #008000;\">_<\/span> \", <span style=\"color: #ff6600;\">A2<\/span> )- <span style=\"color: #3366ff;\">1<\/span> ), \" <span style=\"color: #008000;\">None Found<\/span> \")\n<\/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-39705 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gaucheu3.png\" alt=\"\" width=\"537\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <strong>B9<\/strong> mengembalikan &#8220;Tidak Ditemukan&#8221; karena namanya tidak memiliki garis bawah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa Anda juga dapat mengembalikan nilai yang berbeda hanya dengan mengganti &#8220;Tidak ditemukan&#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-menghapus-karakter-non-numerik\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Hapus karakter non-numerik dari sel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-teks-antara-dua-karakter\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara mengekstrak teks antara dua karakter<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghapus-karakter-terakhir\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara menghapus karakter terakhir dari sebuah string<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi LEFT di Google Spreadsheet untuk mengekstrak sejumlah karakter dari sisi kiri string. Namun, Anda bisa menggunakan rumus berikut untuk menggunakan fungsi LEFT untuk mengekstrak semua karakter dari sisi kiri string hingga karakter tertentu ditemukan: =LEFT(cell, FIND(&#8220;specific_character&#8221;, cell)-1) Misalnya, Anda bisa menggunakan rumus berikut untuk mengekstrak semua karakter dari sisi kiri string [&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 Sheets: rumus KIRI hingga karakter tertentu - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat rumus KIRI hingga karakter tertentu 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-membiarkan-karakternya-terserah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: rumus KIRI hingga karakter tertentu - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat rumus KIRI hingga karakter tertentu di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T18:15:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gaucheu1.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-membiarkan-karakternya-terserah\/\",\"url\":\"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/\",\"name\":\"Google Sheets: rumus KIRI hingga karakter tertentu - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T18:15:16+00:00\",\"dateModified\":\"2023-07-03T18:15:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat rumus KIRI hingga karakter tertentu di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: rumus kiri hingga karakter tertentu\"}]},{\"@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 Sheets: rumus KIRI hingga karakter tertentu - Statologi","description":"Tutorial ini menjelaskan cara membuat rumus KIRI hingga karakter tertentu 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-membiarkan-karakternya-terserah\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: rumus KIRI hingga karakter tertentu - Statologi","og_description":"Tutorial ini menjelaskan cara membuat rumus KIRI hingga karakter tertentu di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/","og_site_name":"Statorials","article_published_time":"2023-07-03T18:15:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gaucheu1.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-membiarkan-karakternya-terserah\/","url":"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/","name":"Google Sheets: rumus KIRI hingga karakter tertentu - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T18:15:16+00:00","dateModified":"2023-07-03T18:15:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat rumus KIRI hingga karakter tertentu di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-membiarkan-karakternya-terserah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: rumus kiri hingga karakter tertentu"}]},{"@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\/5095"}],"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=5095"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5095\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}