{"id":4829,"date":"2023-07-07T11:54:32","date_gmt":"2023-07-07T11:54:32","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/"},"modified":"2023-07-07T11:54:32","modified_gmt":"2023-07-07T11:54:32","slug":"excel-alamat-terpisah-tanpa-koma","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/","title":{"rendered":"Excel: cara memisahkan alamat tanpa koma"},"content":{"rendered":"

<\/p>\n

\n

Saat Anda memiliki alamat dengan koma di Excel, Anda cukup menggunakan fungsi TEXTSPLIT<\/strong> untuk memisahkan alamat menjadi beberapa sel<\/a> .<\/span><\/p>\n

Namun, jika Anda memiliki alamat yang tidak memiliki koma, Anda harus menggunakan fungsi Flash Fill<\/strong> Excel untuk memisahkan alamat menjadi beberapa sel.<\/span><\/p>\n

Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n

Contoh: Cara memisahkan alamat tanpa koma di excel<\/strong><\/span><\/h2>\n

Misalkan kita memiliki daftar alamat berikut di Excel:<\/span> <\/p>\n

\"\"<\/p>\n

Katakanlah kita ingin membagi alamat menjadi sel terpisah yang berisi alamat jalan, kota, negara bagian, dan kode pos di selnya masing-masing.<\/span><\/p>\n

Untuk melakukan ini, pertama-tama kita perlu memasukkan secara manual nilai yang benar untuk jalan, kota, negara bagian, dan kode pos dari alamat pertama:<\/span> <\/p>\n

\"\"<\/p>\n

Selanjutnya, kita dapat menyorot cell range B2:B9<\/strong> :<\/span><\/span> <\/p>\n

\"\"<\/p>\n

Dengan menyorot rentang ini, kita kemudian dapat mengklik tombol Fill<\/strong> di grup Editing<\/strong> pada tab Home<\/strong> dan klik opsi Flash Fill<\/strong> di menu drop-down:<\/span> <\/p>\n

\"\"<\/p>\n

Alat ini secara otomatis akan mengisi alamat surat yang benar untuk setiap baris:<\/span> <\/p>\n

\"\"<\/p>\n

Gunakan kembali fungsi Flash Fill<\/strong> pada kolom kota, negara bagian, dan kode pos untuk mengisi nilai yang benar:<\/span> <\/p>\n

\"Alamat<\/p>\n

Perhatikan bahwa setiap alamat telah berhasil dipecah menjadi sel terpisah yang menunjukkan alamat jalan, kota, negara bagian, dan kode pos.<\/span><\/p>\n

Catatan<\/strong> : Fitur Flash Fill<\/strong> di Excel berguna ketika Anda bisa secara manual memberikan contoh nilai benar yang perlu diisi, lalu Anda bisa membiarkan Flash Fill mengidentifikasi pola di data Anda dan mengisi nilai yang tersisa.<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h2>\n

Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n

Excel: cara menghitung jika sel berisi teks<\/a>
Excel: Cara membagi sebuah kata menjadi huruf-huruf tersendiri<\/a>
Excel: Cara mengekstrak teks antara dua karakter<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Saat Anda memiliki alamat dengan koma di Excel, Anda cukup menggunakan fungsi TEXTSPLIT untuk memisahkan alamat menjadi beberapa sel . Namun, jika Anda memiliki alamat yang tidak memiliki koma, Anda harus menggunakan fungsi Flash Fill Excel untuk memisahkan alamat menjadi beberapa sel. Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Cara memisahkan alamat tanpa koma […]<\/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":"\nExcel: Cara memisahkan alamat tanpa koma - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memisahkan alamat di Excel tanpa koma, 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\/excel-alamat-terpisah-tanpa-koma\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara memisahkan alamat tanpa koma - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memisahkan alamat di Excel tanpa koma, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T11:54:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spa1-1.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-alamat-terpisah-tanpa-koma\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/\",\"name\":\"Excel: Cara memisahkan alamat tanpa koma - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T11:54:32+00:00\",\"dateModified\":\"2023-07-07T11:54:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memisahkan alamat di Excel tanpa koma, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memisahkan alamat tanpa koma\"}]},{\"@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 memisahkan alamat tanpa koma - Statorials","description":"Tutorial ini menjelaskan cara memisahkan alamat di Excel tanpa koma, 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\/excel-alamat-terpisah-tanpa-koma\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara memisahkan alamat tanpa koma - Statorials","og_description":"Tutorial ini menjelaskan cara memisahkan alamat di Excel tanpa koma, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/","og_site_name":"Statorials","article_published_time":"2023-07-07T11:54:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/spa1-1.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-alamat-terpisah-tanpa-koma\/","url":"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/","name":"Excel: Cara memisahkan alamat tanpa koma - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T11:54:32+00:00","dateModified":"2023-07-07T11:54:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memisahkan alamat di Excel tanpa koma, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-alamat-terpisah-tanpa-koma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memisahkan alamat tanpa koma"}]},{"@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\/4829"}],"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=4829"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4829\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}