{"id":1809,"date":"2023-11-03T04:01:28","date_gmt":"2023-11-03T04:01:28","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/"},"modified":"2023-12-06T06:15:27","modified_gmt":"2023-12-06T06:15:27","slug":"tambahkan-koma","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/","title":{"rendered":"Bagaimana cara menambahkan koma di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1751945886\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Jika Anda ingin menambahkan koma sebelum atau sesudah nilai sel, Anda bisa menulis rumus berbeda di Excel. Untuk melakukan ini, Anda harus menggunakan metode penggabungan atau fungsi yang memungkinkan Anda menggabungkan dua nilai atau lebih.<\/p><p> Dalam tutorial ini, kami akan merinci rumus-rumus ini.<\/p><h2 class=\"wp-block-heading\"> Menggunakan ampersand untuk menambahkan koma<\/h2><p> Pada contoh di bawah, Anda memiliki dua sel, A1 dan B1, dengan nilai teks. Anda perlu menggabungkan nilai-nilai ini dari sel-sel ini dan menambahkan koma di antara mereka.<\/p><p> Gunakan rumus di bawah ini untuk melakukan ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13636\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png\" alt=\"rumus-untuk-menambahkan-koma\" width=\"514\" height=\"259\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png 582w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules-300x151.png 300w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&amp;\", \"&amp;B1<\/code><\/pre><p> Dalam rumus ini Anda memiliki nilai dari sel A1 dan B1. Dan dengan bantuan tanda kutip ganda, ada koma dan spasi di antara kedua nilai tersebut.<\/p><p> Atau Anda juga bisa melakukannya menggunakan fungsi CONCATENATE. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCATENATE(A1,\", \",B1)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13637\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-une-virgule-en-utilisant-concatenation.png\" alt=\"tambahkan koma menggunakan penggabungan\" width=\"512\" height=\"258\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-une-virgule-en-utilisant-concatenation.png 582w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-une-virgule-en-utilisant-concatenation-300x151.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\"><\/figure><\/div><p> Dan jika Anda sudah memiliki koma di sel, Anda bisa menggunakan fungsi CONCAT untuk itu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13638\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/concat-si-a-deja-une-virgules.png\" alt=\"concat-jika-sudah-memiliki-koma\" width=\"507\" height=\"202\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/concat-si-a-deja-une-virgules.png 736w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/concat-si-a-deja-une-virgules-300x119.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Anda bisa menggunakan metode ini di versi Excel mana pun.<\/p><h2 class=\"wp-block-heading\"> Gunakan TEXTJOIN untuk menambahkan koma di antara beberapa nilai<\/h2><p> Jika Anda ingin menambahkan koma di antara beberapa nilai dalam rentang sel, TEXTJOIN adalah fungsi terbaik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13639\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/textjoin-to-add-comma.png\" alt=\"textjoin-to-add-koma\" width=\"447\" height=\"342\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/textjoin-to-add-comma.png 588w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/textjoin-to-add-comma-300x230.png 300w\" sizes=\"auto, (max-width: 447px) 100vw, 447px\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\", \",TRUE,A1:A5)<\/code><\/pre><p> Sangat mudah untuk menambahkan koma atau pembatas lainnya dengan TEXTJOIN. Seperti yang Anda lihat:<\/p><ul><li> Kami telah menentukan koma dan spasi di argumen pertama fungsi tersebut.<\/li><li> Dan kemudian TRUE untuk mengabaikan sel kosong.<\/li><li> Pada akhirnya, kami merujuk pada kisaran dari mana kami ingin mencapainya.<\/li><\/ul><p> Saat Anda menekan Enter, ini memberi Anda semua nilai dengan koma dan spasi di antara setiap kata. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-une-virgule.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/baris-baru-di-sel\/\">Tambahkan baris baru ke sel di Excel (jeda baris)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/angka-nol-di-depan\/\">Tambahkan angka nol di depan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-dengan-koma\/\">Gabungkan (gabungkan) sel dengan koma di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyatukan-sejumlah-sel\/\">Menggabungkan (menggabungkan) sejumlah sel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-jeda-baris\/\">Gabungkan dengan jeda baris di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1809","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menambahkan koma di Excel? (Sel - Teks)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan koma setelah atau sebelum nilai. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan koma di Excel? (Sel - Teks)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan koma setelah atau sebelum nilai. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan koma di Excel? (Sel - Teks)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png\",\"datePublished\":\"2023-11-03T04:01:28+00:00\",\"dateModified\":\"2023-12-06T06:15:27+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan koma setelah atau sebelum nilai. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan koma di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menambahkan koma di Excel? (Sel - Teks)","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan koma setelah atau sebelum nilai. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/tambahkan-koma\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan koma di Excel? (Sel - Teks)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan koma setelah atau sebelum nilai. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/","url":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/","name":"\u25b7 Bagaimana cara menambahkan koma di Excel? (Sel - Teks)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png","datePublished":"2023-11-03T04:01:28+00:00","dateModified":"2023-12-06T06:15:27+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan koma setelah atau sebelum nilai. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tambahkan-koma\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/formule-a-ajouter-virgules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-koma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan koma di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1809"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1809\/revisions"}],"predecessor-version":[{"id":2412,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1809\/revisions\/2412"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}