{"id":1500,"date":"2023-11-20T05:19:51","date_gmt":"2023-11-20T05:19:51","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/"},"modified":"2023-12-06T06:15:46","modified_gmt":"2023-12-06T06:15:46","slug":"tambahkan-spasi-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/","title":{"rendered":"Bagaimana cara menambahkan spasi ke sel excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3718372735\"><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>Saat Anda menggabungkan dua nilai dalam satu sel, biasanya perlu menambahkan spasi di antara nilai tersebut. Bahkan terkadang Anda perlu menambahkan lebih dari satu spasi. Tutorial ini akan membantu Anda menulis rumus untuk menambahkan spasi atau beberapa spasi di Excel.<\/p><h2 class=\"wp-block-heading\"> Tambahkan satu spasi<\/h2><ol type=\"1\"><li> Pertama, masukkan (=) ke dalam sel.<\/li><li> Rujuk ke sel dengan nilai pertama dan ketikkan ampersand (&amp;).<\/li><li> Ketik (\u201c\u201d) untuk menentukan spasi yang akan ditambahkan.<\/li><li> Sekarang, rujuk ke sel dengan nilai kedua dan ketikkan ampersand (&amp;).<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12824 \" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png\" alt=\"1 tambahkan satu spasi\" width=\"535\" height=\"110\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png 564w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique-300x62.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\"><\/figure><\/div><p> Saat Anda menekan Enter, Anda akan mendapatkan kedua nilai dalam satu sel dengan spasi di antaranya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12825 \" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/2-Excel-a-espace-unique.png\" alt=\"2 Spasi Tunggal Excel\" width=\"542\" height=\"107\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/2-Excel-a-espace-unique.png 557w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/2-Excel-a-espace-unique-300x59.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&amp;\" \"&amp;B1<\/code><\/pre><h2 class=\"wp-block-heading\"> Tambahkan beberapa spasi<\/h2><p> Sekarang jika Anda ingin menambahkan lebih dari satu spasi di antara dua nilai, Anda dapat menggunakan fungsi REPT. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-12827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/4-Excel-a-espaces-multiples.png\" alt=\"4 Excel Multispasi\" width=\"608\" height=\"135\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/4-Excel-a-espaces-multiples.png 693w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/4-Excel-a-espaces-multiples-300x67.png 300w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\"><\/figure><\/div><p> Daripada menggunakan satu spasi dalam rumus ini, kami menggunakan REPT. Dan di REPT, kami menentukan spasi dan nomor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-12826\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/3-ajouter-plusieurs-espaces.png\" alt=\"3 tambahkan banyak spasi\" width=\"605\" height=\"147\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/3-ajouter-plusieurs-espaces.png 691w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/3-ajouter-plusieurs-espaces-300x73.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\"><\/figure><\/div><p> Seperti yang Anda lihat, kita memiliki 20 untuk argumen number_times, yang memberitahu fungsi untuk mengembalikan 20 spasi di antara dua kata.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&amp;REPT(\" \",20)&amp;B1<\/code><\/pre><h2 class=\"wp-block-heading\"> Tambahkan beberapa spasi untuk beberapa nilai<\/h2><p> Jika Anda memiliki beberapa nilai dan ingin menambahkan spasi di antara setiap nilai saat menggabungkannya, Anda dapat menggunakan fungsi TEXTJOIN. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83043\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ajouter-plusieurs-espaces-pour-plusieurs-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan-beberapa-ruang-untuk-banyak-nilai\" width=\"441\" height=\"319\"><\/figure><\/div><p> Di TEXTJOIN Anda perlu menentukan pembatas yang akan ditambahkan di antara setiap nilai, dan di sini kita memiliki spasi. Setelah itu, TRUE untuk mengabaikan sel kosong, dan di akhir, rentang untuk mendapatkan nilainya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\" \",TRUE,A1:A5)<\/code><\/pre><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-de-lespace-dans-Excel.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 class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1500","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 spasi di sel Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan spasi di antara dua 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-spasi-2\/\" \/>\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 spasi di sel Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan spasi di antara dua nilai. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.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-spasi-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan spasi di sel Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png\",\"datePublished\":\"2023-11-20T05:19:51+00:00\",\"dateModified\":\"2023-12-06T06:15:46+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan spasi di antara dua nilai. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan spasi ke sel 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 spasi di sel Excel?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan spasi di antara dua 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-spasi-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan spasi di sel Excel?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan spasi di antara dua nilai. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.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-spasi-2\/","url":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/","name":"\u25b7 Bagaimana cara menambahkan spasi di sel Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png","datePublished":"2023-11-20T05:19:51+00:00","dateModified":"2023-12-06T06:15:46+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan spasi di antara dua nilai. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/1-ajouter-un-espace-unique.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-spasi-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan spasi ke sel 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\/1500","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=1500"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1500\/revisions"}],"predecessor-version":[{"id":2450,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1500\/revisions\/2450"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}