{"id":4653,"date":"2023-07-09T06:41:29","date_gmt":"2023-07-09T06:41:29","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/"},"modified":"2023-07-09T06:41:29","modified_gmt":"2023-07-09T06:41:29","slug":"excel-ganti-koma-dengan-pemisah-baris","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/","title":{"rendered":"Excel: cara mengganti koma dengan jeda baris"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan proses dua langkah berikut untuk mengganti koma dengan jeda baris di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Gunakan rumus SUBSTITUTE<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\",\",CHAR(10))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Aktifkan pembungkusan teks<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36313 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb1.png\" alt=\"\" width=\"593\" height=\"165\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara mengganti koma dengan jeda baris di Excel dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Ganti koma dengan jeda baris di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom berikut di Excel yang berisi nama tim, posisi dan poin yang dicetak oleh 10 pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36314 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb2.png\" alt=\"\" width=\"474\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengganti koma di setiap sel dengan baris baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\",\",CHAR(10))<\/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-36315 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb3.png\" alt=\"\" width=\"533\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>B2:B11<\/strong> , dan klik ikon <strong>Bungkus Teks<\/strong> di grup <strong>Alignment<\/strong> pada tab <strong>Beranda<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36313 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb1.png\" alt=\"\" width=\"593\" height=\"165\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sel dalam rentang <strong>B2:B11<\/strong> akan diformat dengan jeda baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36316\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb4.png\" alt=\"Excel mengganti koma dengan jeda baris\" width=\"417\" height=\"510\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fitur <strong>Bungkus Teks<\/strong> di Excel digunakan untuk menampilkan semua teks dalam sel tertentu tanpa membiarkannya tersebar ke sel lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami menggunakan fungsi <strong>SUBSTITUTE<\/strong> untuk mengganti koma dengan jeda baris, tetapi untuk memvisualisasikan jeda baris ini kami harus mengaktifkan <strong>Bungkus Teks<\/strong> sehingga Excel menampilkan teks di setiap sel dengan beberapa baris.<\/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-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti sel kosong dengan nol di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pencarian-excel-untuk-karakter-khusus\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Karakter Khusus dalam Sel di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan proses dua langkah berikut untuk mengganti koma dengan jeda baris di Excel: Langkah 1: Gunakan rumus SUBSTITUTE =SUBSTITUTE( A2 ,&#8221;,&#8221;,CHAR(10)) Langkah 2: Aktifkan pembungkusan teks Contoh berikut menunjukkan cara mengganti koma dengan jeda baris di Excel dalam praktiknya. Contoh: Ganti koma dengan jeda baris di Excel Misalkan kita memiliki kolom berikut di [&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 mengganti koma dengan jeda baris - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti koma dengan jeda baris di sel Excel, 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-ganti-koma-dengan-pemisah-baris\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengganti koma dengan jeda baris - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti koma dengan jeda baris di sel Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T06:41:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb1.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-ganti-koma-dengan-pemisah-baris\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/\",\"name\":\"Excel: Cara mengganti koma dengan jeda baris - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T06:41:29+00:00\",\"dateModified\":\"2023-07-09T06:41:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti koma dengan jeda baris di sel Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengganti koma dengan jeda baris\"}]},{\"@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 mengganti koma dengan jeda baris - Statorials","description":"Tutorial ini menjelaskan cara mengganti koma dengan jeda baris di sel Excel, 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-ganti-koma-dengan-pemisah-baris\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengganti koma dengan jeda baris - Statorials","og_description":"Tutorial ini menjelaskan cara mengganti koma dengan jeda baris di sel Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/","og_site_name":"Statorials","article_published_time":"2023-07-09T06:41:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligneb1.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-ganti-koma-dengan-pemisah-baris\/","url":"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/","name":"Excel: Cara mengganti koma dengan jeda baris - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T06:41:29+00:00","dateModified":"2023-07-09T06:41:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti koma dengan jeda baris di sel Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-ganti-koma-dengan-pemisah-baris\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengganti koma dengan jeda baris"}]},{"@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\/4653"}],"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=4653"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4653\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}