{"id":5103,"date":"2023-07-03T14:48:38","date_gmt":"2023-07-03T14:48:38","guid":{"rendered":"https:\/\/statorials.org\/id\/sub-string-excel\/"},"modified":"2023-07-03T14:48:38","modified_gmt":"2023-07-03T14:48:38","slug":"sub-string-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sub-string-excel\/","title":{"rendered":"Cara mengekstrak substring di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk mengekstrak substring tertentu dari teks di Excel:<\/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 3 characters of string in cell A2<\/span>\n<span style=\"color: #000000;\">=LEFT( <span style=\"color: #3366ff;\">A2,3<\/span> )\n<\/span><\/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 8 characters of string in cell A2 starting at position 2<\/span>\n=MID( <span style=\"color: #3366ff;\">A2,2,8<\/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 3 characters of string in cell A2<\/span>\n=RIGHT( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #000000;\">3)<\/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 A2<\/span>\n=TEXTBEFORE( <span style=\"color: #3366ff;\">A2<\/span> , \"there\")<\/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 A2<\/span>\n=TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> , \"there\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Metode 1: Kembalikan substring dari awal string<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>LEFT()<\/strong> untuk mengembalikan tiga karakter pertama sel <strong>A2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39764\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es1.png\" alt=\"Excel mendapatkan substring dari awal string\" width=\"429\" height=\"324\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Metode 2: Kembalikan substring dari tengah string<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>MID()<\/strong> untuk mengembalikan delapan karakter di tengah sel <strong>A2<\/strong> , dimulai dari posisi 2:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39765\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es2.png\" alt=\"Excel mendapatkan substring tengah dari string\" width=\"442\" height=\"353\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Metode 3: Kembalikan substring dari akhir string<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>RIGHT()<\/strong> untuk mengembalikan tiga karakter terakhir sel <strong>A2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39766\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es3.png\" alt=\"Excel mendapat substring dari akhir string\" width=\"435\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Metode 4:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Kembalikan Substring Sebelum Beberapa Teks<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>TEXTBEFORE()<\/strong> untuk mengembalikan semua teks sebelum string &#8220;di sana&#8221; di sel <strong>A2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39767\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es4.png\" alt=\"Excel mendapat substring sebelum teks tertentu\" width=\"444\" height=\"324\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Metode 5:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Kembalikan substring setelah teks tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>TEXTAFTER()<\/strong> untuk mengembalikan semua teks yang muncul setelah string &#8220;di sana&#8221; di sel <strong>A2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39768\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es5.png\" alt=\"Excel mendapat substring setelah teks tertentu\" width=\"434\" height=\"343\" srcset=\"\" sizes=\"\"><\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-pertama-dan-terakhir\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menghapus karakter pertama dan terakhir dari sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-huruf-pertama-dalam-string\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan huruf pertama dari sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-angka-pertama-dalam-string\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan angka pertama dalam string teks<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk mengekstrak substring tertentu dari teks di Excel: Metode 1: Kembalikan substring dari awal string #return first 3 characters of string in cell A2 =LEFT( A2,3 ) Metode 2: Kembalikan substring dari tengah string #return 8 characters of string in cell A2 starting at position 2 =MID( A2,2,8 ) Metode [&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 Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak substring dari string di Excel, 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\/sub-string-excel\/\" \/>\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 Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak substring dari string di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sub-string-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T14:48:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es1.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\/sub-string-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/sub-string-excel\/\",\"name\":\"Cara Mengekstrak Substring di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T14:48:38+00:00\",\"dateModified\":\"2023-07-03T14:48:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak substring dari string di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sub-string-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sub-string-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sub-string-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengekstrak substring di excel (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 Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengekstrak substring dari string di Excel, 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\/sub-string-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengekstrak Substring di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengekstrak substring dari string di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sub-string-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-03T14:48:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/es1.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\/sub-string-excel\/","url":"https:\/\/statorials.org\/id\/sub-string-excel\/","name":"Cara Mengekstrak Substring di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T14:48:38+00:00","dateModified":"2023-07-03T14:48:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak substring dari string di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sub-string-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sub-string-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sub-string-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengekstrak substring di excel (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\/5103"}],"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=5103"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5103\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}