{"id":5053,"date":"2023-07-04T12:16:16","date_gmt":"2023-07-04T12:16:16","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/"},"modified":"2023-07-04T12:16:16","modified_gmt":"2023-07-04T12:16:16","slug":"excel-membagi-string-berdasarkan-panjangnya","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/","title":{"rendered":"Excel: cara membagi string dengan panjang tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fitur <strong>Teks ke Kolom<\/strong> di tab <strong>Data<\/strong> Excel untuk membagi string dengan panjang tertentu menjadi beberapa kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara membagi string dengan panjang tertentu di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom ID karyawan berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39397 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl1.png\" alt=\"\" width=\"494\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap ID karyawan terdiri dari total sembilan karakter.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membagi setiap string ID karyawan menjadi potongan tiga huruf menjadi tiga kolom terpisah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menyorot rentang sel <strong>A2:A9<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Teks ke Kolom<\/strong> di grup <b>Alat Data<\/b> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38497 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/splitcom2.png\" alt=\"\" width=\"585\" height=\"176\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada kotak baru yang muncul, centang kotak di samping <strong>Lebar tetap<\/strong> , lalu klik <strong>Berikutnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39398 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl2.png\" alt=\"\" width=\"565\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Di kotak putih, klik lokasi di mana Anda ingin membagi teks.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita akan mengklik sekali setelah rangkaian tiga karakter pertama, lalu klik lagi setelah rangkaian tiga karakter kedua untuk membuat dua garis yang terlihat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39399 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl3.png\" alt=\"\" width=\"543\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik <strong>Berikutnya<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketik <strong>$C$2<\/strong> di kotak <strong>Tujuan<\/strong> , lalu klik <strong>Selesai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39400 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl4.png\" alt=\"\" width=\"590\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap string di kolom A akan otomatis dipecah menjadi tiga kolom baru, masing-masing berisi tiga karakter dari string ID karyawan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39401\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl5.png\" alt=\"Excel membagi string berdasarkan panjangnya\" width=\"490\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kami memilih untuk membagi string berdasarkan panjangnya 3, tetapi Anda dapat memilih untuk membaginya menjadi berapa pun panjangnya yang Anda inginkan dengan menentukan jeda baris pada langkah kedua fitur <strong>Teks<\/strong> <strong>di kolom<\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/string-excel-dibagi-dengan-koma\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara membagi string dengan koma<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/alamat-pemisahan-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membagi alamat menjadi beberapa sel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-membagi-kata-menjadi-huruf\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara membagi sebuah kata menjadi huruf-huruf tersendiri<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fitur Teks ke Kolom di tab Data Excel untuk membagi string dengan panjang tertentu menjadi beberapa kolom. Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik. Contoh: Cara membagi string dengan panjang tertentu di Excel Misalkan kita memiliki kolom ID karyawan berikut di Excel: Setiap ID karyawan terdiri dari total sembilan karakter. [&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 Membagi String Berdasarkan Panjang Tertentu \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membagi string di Excel dengan panjang tertentu, 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\/excel-membagi-string-berdasarkan-panjangnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Membagi String Berdasarkan Panjang Tertentu \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membagi string di Excel dengan panjang tertentu, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T12:16:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl1.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\/excel-membagi-string-berdasarkan-panjangnya\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/\",\"name\":\"Excel: Cara Membagi String Berdasarkan Panjang Tertentu \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T12:16:16+00:00\",\"dateModified\":\"2023-07-04T12:16:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membagi string di Excel dengan panjang tertentu, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membagi string dengan panjang 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":"Excel: Cara Membagi String Berdasarkan Panjang Tertentu \u2013 Statologi","description":"Tutorial ini menjelaskan cara membagi string di Excel dengan panjang tertentu, 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\/excel-membagi-string-berdasarkan-panjangnya\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membagi String Berdasarkan Panjang Tertentu \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara membagi string di Excel dengan panjang tertentu, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/","og_site_name":"Statorials","article_published_time":"2023-07-04T12:16:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sl1.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\/excel-membagi-string-berdasarkan-panjangnya\/","url":"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/","name":"Excel: Cara Membagi String Berdasarkan Panjang Tertentu \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T12:16:16+00:00","dateModified":"2023-07-04T12:16:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membagi string di Excel dengan panjang tertentu, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-membagi-string-berdasarkan-panjangnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membagi string dengan panjang 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\/5053"}],"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=5053"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5053\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}