{"id":4697,"date":"2023-07-08T20:50:07","date_gmt":"2023-07-08T20:50:07","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/"},"modified":"2023-07-08T20:50:07","modified_gmt":"2023-07-08T20:50:07","slug":"excel-mengekstrak-teks-demi-karakter","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/","title":{"rendered":"Excel: cara mengekstrak teks setelah karakter"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <b>TEXTAFTER<\/b> di Excel untuk mengekstrak semua teks dalam sel setelah karakter atau substring tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>TEXTAFTER(teks, pembatas, [nomor_instance], [mode_pertandingan], [akhir_pertandingan], [if_not_found])<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>teks<\/strong> : Teks yang akan dicari<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>pembatas<\/strong> : Karakter atau substring untuk mengekstrak teks setelahnya<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>instance_num (opsional)<\/strong> : contoh pembatas setelah mengekstrak teks (defaultnya adalah 1)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>match_mode (opsional)<\/strong> : 0 = peka huruf besar-kecil (default), 1 = tidak peka huruf besar-kecil<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>match_end (opsional)<\/strong> : Perlakukan akhir teks sebagai pembatas (dinonaktifkan secara default)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>if_not_found (opsional)<\/strong> : Nilai yang akan dikembalikan jika pembatas tidak ditemukan<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara paling umum untuk menggunakan fungsi ini dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36677 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tb1.png\" alt=\"\" width=\"515\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-sebelum-karakter\/\" target=\"_blank\" rel=\"noopener\">Cara Mengekstrak Teks Sebelum Karakter di Excel<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Ekstrak teks setelah substring<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengekstrak teks dari sel <strong>A2<\/strong> setelah menemukan substring &#8220;is&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> , \"is\")<\/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-36688 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ta1-1.png\" alt=\"\" width=\"564\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B berisi teks dari kolom A setelah bertemu dengan substring \u201cis\u201d.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Ekstrak teks setelah spasi pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengekstrak teks dari sel <strong>A2<\/strong> setelah menemukan spasi pertama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/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-36689 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ta2.png\" alt=\"\" width=\"579\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B berisi teks dari kolom A setelah bertemu spasi pertama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Ekstrak teks setelah spasi ke-n<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengekstrak teks dari sel <strong>A2<\/strong> setelah spasi ketiga ditemukan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> , \" \", 3)<\/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-36690 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ta3.png\" alt=\"\" width=\"529\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B memuat seluruh teks pada kolom A setelah bertemu spasi ketiga.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <b>TEXTAFTER<\/b> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4\" target=\"_blank\" rel=\"noopener\">di sini<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-menghapus-teks-tertentu-dari-sel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menghapus teks tertentu dari sel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-menghapus-karakter-khusus\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghapus karakter khusus<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menyisipkan-karakter-ke-dalam-string\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara memasukkan karakter ke dalam string<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi TEXTAFTER di Excel untuk mengekstrak semua teks dalam sel setelah karakter atau substring tertentu. Fungsi ini menggunakan sintaks berikut: TEXTAFTER(teks, pembatas, [nomor_instance], [mode_pertandingan], [akhir_pertandingan], [if_not_found]) Emas: teks : Teks yang akan dicari pembatas : Karakter atau substring untuk mengekstrak teks setelahnya instance_num (opsional) : contoh pembatas setelah mengekstrak teks (defaultnya adalah [&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>Excel: Cara mengekstrak teks setelah karakter - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak teks setelah karakter tertentu di Excel, 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\/excel-mengekstrak-teks-demi-karakter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengekstrak teks setelah karakter - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak teks setelah karakter tertentu di Excel, dengan contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T20:50:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tb1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/\",\"name\":\"Excel: Cara mengekstrak teks setelah karakter - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T20:50:07+00:00\",\"dateModified\":\"2023-07-08T20:50:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak teks setelah karakter tertentu di Excel, dengan contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengekstrak teks setelah 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":"Excel: Cara mengekstrak teks setelah karakter - Statorials","description":"Tutorial ini menjelaskan cara mengekstrak teks setelah karakter tertentu di Excel, 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\/excel-mengekstrak-teks-demi-karakter\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengekstrak teks setelah karakter - Statorials","og_description":"Tutorial ini menjelaskan cara mengekstrak teks setelah karakter tertentu di Excel, dengan contoh.","og_url":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/","og_site_name":"Statorials","article_published_time":"2023-07-08T20:50:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tb1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/","url":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/","name":"Excel: Cara mengekstrak teks setelah karakter - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T20:50:07+00:00","dateModified":"2023-07-08T20:50:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak teks setelah karakter tertentu di Excel, dengan contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengekstrak-teks-demi-karakter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengekstrak teks setelah 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\/4697"}],"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=4697"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4697\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}