{"id":3805,"date":"2023-07-15T11:00:39","date_gmt":"2023-07-15T11:00:39","guid":{"rendered":"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/"},"modified":"2023-07-15T11:00:39","modified_gmt":"2023-07-15T11:00:39","slug":"ekstrak-kata-terakhir-di-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/","title":{"rendered":"Google sheets: cara mengekstrak kata terakhir dari sel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengekstrak kata terakhir dari sel di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TRIM(RIGHT(SUBSTITUTE( <span style=\"color: #ff6600;\">A2<\/span> ,\" \",REPT(\" \",LEN( <span style=\"color: #ff6600;\">A2<\/span> ))),LEN( <span style=\"color: #ff6600;\">A2<\/span> )))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan mengekstrak kata terakhir dari sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Ekstrak kata terakhir dari sel 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-30852 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dernier1.jpg\" alt=\"\" width=\"457\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mengekstrak kata terakhir dari sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TRIM(RIGHT(SUBSTITUTE( <span style=\"color: #ff6600;\">A2<\/span> ,\" \",REPT(\" \",LEN( <span style=\"color: #ff6600;\">A2<\/span> ))),LEN( <span style=\"color: #ff6600;\">A2<\/span> )))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>B2<\/strong> dan tekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30853 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dernier2.jpg\" alt=\"\" width=\"617\" height=\"512\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya dengan benar mengembalikan kata <strong>fast<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom B untuk mengekstrak kata terakhir dari setiap sel di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30854\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dernier3.jpg\" alt=\"Google Sheets mengekstrak kata terakhir dari sel\" width=\"599\" height=\"491\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya dengan benar mengekstrak kata terakhir dari setiap sel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus ini berfungsi terlepas dari panjang string atau frasa dalam sel tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa rumus ini berfungsi ketika string hanya berisi satu kata, seperti string di sel <strong>A5<\/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 hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <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\/lembar-google-tidak-mengandung\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Memfilter sel yang tidak berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-meninggalkan-string-terbalik\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara membalikkan string teks<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengekstrak kata terakhir dari sel di Google Spreadsheet: =TRIM(RIGHT(SUBSTITUTE( A2 ,&#8221; &#8220;,REPT(&#8221; &#8220;,LEN( A2 ))),LEN( A2 ))) Rumus khusus ini akan mengekstrak kata terakhir dari sel A2 . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Ekstrak kata terakhir dari sel di Google Sheets Katakanlah kita memiliki [&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 kata terakhir dari sel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak kata terakhir 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\/ekstrak-kata-terakhir-di-lembar-google\/\" \/>\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 kata terakhir dari sel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak kata terakhir dari sel di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T11:00:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dernier1.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\/ekstrak-kata-terakhir-di-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/\",\"name\":\"Google Spreadsheet: Cara mengekstrak kata terakhir dari sel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T11:00:39+00:00\",\"dateModified\":\"2023-07-15T11:00:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak kata terakhir dari sel di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengekstrak kata terakhir dari sel\"}]},{\"@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 kata terakhir dari sel - Statologi","description":"Tutorial ini menjelaskan cara mengekstrak kata terakhir 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\/ekstrak-kata-terakhir-di-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengekstrak kata terakhir dari sel - Statologi","og_description":"Tutorial ini menjelaskan cara mengekstrak kata terakhir dari sel di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-15T11:00:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dernier1.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\/ekstrak-kata-terakhir-di-lembar-google\/","url":"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/","name":"Google Spreadsheet: Cara mengekstrak kata terakhir dari sel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T11:00:39+00:00","dateModified":"2023-07-15T11:00:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak kata terakhir dari sel di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ekstrak-kata-terakhir-di-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengekstrak kata terakhir dari sel"}]},{"@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\/3805"}],"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=3805"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3805\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}