{"id":1671,"date":"2023-11-12T14:04:35","date_gmt":"2023-11-12T14:04:35","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/"},"modified":"2023-12-06T06:16:01","modified_gmt":"2023-12-06T06:16:01","slug":"kembalikan-nama-depan-koma-di-antara","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/","title":{"rendered":"Bagaimana cara mengekstrak nama depan dan belakang dengan koma?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3934560085\"><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>Untuk mengubah nama depan dan belakang menjadi nama depan dan belakang di Excel, Anda perlu menggunakan kombinasi fungsi MID, LEN, dan SEARCH. Dalam tutorial ini, kita akan belajar bagaimana menulis rumus untuk ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12335 size-full\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png\" alt=\"Kembalikan yang pertama &amp;amp;\" width=\"487\" height=\"301\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png 487w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp-300x185.png 300w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus excel untuk mengubah nama depan dan belakang<\/h2><p> Anda dapat menggunakan langkah-langkah berikut untuk menulis rumus ini:<\/p><ol><li> Pertama, Anda perlu menggunakan fungsi SEARCH untuk menemukan spasi antara nama depan dan nama belakang.<br><br><\/li><li> Setelah itu, tambahkan satu ke nomor yang dihasilkan oleh pencarian.<br><br><\/li><li> Maka Anda perlu menggunakan fungsi LEN untuk mendapatkan jumlah karakter (nama depan dan belakang). Dan tambahkan 1 ke dalamnya juga.<br><br><\/li><li> Sekarang masukkan fungsi MID, dan di argumen pertama masukkan sel A1 (di mana Anda memiliki namanya) dua kali menggabungkannya dengan koma dan spasi.<br><br><\/li><li> Dari sana, dalam argumen MID kedua dan ketiga, masukkan fungsi SEARCH dan fungsi LEN (yang kita tulis di langkah sebelumnya).<br><br><\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MID(A1&amp;\", \"&amp;A1,SEARCH(\" \",A1)+1,LEN(A1)+1)<\/code><\/pre><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Untuk memahami rumus ini, Anda perlu membaginya menjadi tiga bagian. Fungsi utamanya adalah fungsi MID dan kami memiliki tiga argumen di fungsi tengah untuk didefinisikan, dan itulah mengapa Anda perlu membagi rumus ini menjadi tiga bagian untuk memahaminya.<\/p><p> Di <strong>BAGIAN SATU<\/strong> kita memiliki argumen tekstual MID. Dan dalam argumen ini, kami menggabungkan nama depan dan belakang dua kali menggunakan koma dan spasi.<\/p><p> Di <strong>BAGIAN DUA<\/strong> Anda memiliki fungsi SEARCH yang merujuk ke sel A1 di mana Anda memiliki nama (depan dan terakhir) dan mencari spasi di dalamnya lalu menambahkan 1 di dalamnya. Dengan cara ini Anda mendapatkan posisi awal dari nama belakang sel.<\/p><p> Di <strong>PART THREE<\/strong> , Anda memiliki fungsi LEN yang menghitung jumlah karakter dari nama asli (depan dan belakang) dan menambahkan 1 ke dalamnya.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><\/figure><\/div><p> Pada akhirnya, fungsi MID mendapatkan nama belakang dari nilai pertama dan nama depan dari nilai kedua untuk memberi Anda hasil pertukaran nama depan dan nama belakang menjadi nama belakang dan nama depan. <\/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 href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/changer-les-prenoms.xlsx\">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\/menggunakan-huruf-kapital-pada-huruf-pertama\/\">Gunakan huruf besar pada huruf pertama di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kolom-ke-baris\/\">Ubah kolom ke baris (sebaliknya) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kasus-kalimat\/\">Beralih ke Kasus Kalimat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-huruf-besarkecil-teks\/\">Mengubah huruf besar\/kecil (huruf besar, huruf kecil, benar)<\/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-1671","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 mengekstrak nama depan dan belakang dengan koma?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membalikkan nama depan dan belakang serta menambahkan koma di antaranya.\" \/>\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\/kembalikan-nama-depan-koma-di-antara\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengekstrak nama depan dan belakang dengan koma?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membalikkan nama depan dan belakang serta menambahkan koma di antaranya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/\",\"name\":\"\u25b7 Bagaimana cara mengekstrak nama depan dan belakang dengan koma?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png\",\"datePublished\":\"2023-11-12T14:04:35+00:00\",\"dateModified\":\"2023-12-06T06:16:01+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membalikkan nama depan dan belakang serta menambahkan koma di antaranya.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengekstrak nama depan dan belakang dengan koma?\"}]},{\"@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 mengekstrak nama depan dan belakang dengan koma?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membalikkan nama depan dan belakang serta menambahkan koma di antaranya.","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\/kembalikan-nama-depan-koma-di-antara\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengekstrak nama depan dan belakang dengan koma?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membalikkan nama depan dan belakang serta menambahkan koma di antaranya.","og_url":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/","url":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/","name":"\u25b7 Bagaimana cara mengekstrak nama depan dan belakang dengan koma?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png","datePublished":"2023-11-12T14:04:35+00:00","dateModified":"2023-12-06T06:16:01+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membalikkan nama depan dan belakang serta menambahkan koma di antaranya.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Retournez-le-premier-amp.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kembalikan-nama-depan-koma-di-antara\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengekstrak nama depan dan belakang dengan koma?"}]},{"@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\/1671","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=1671"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1671\/revisions"}],"predecessor-version":[{"id":2481,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1671\/revisions\/2481"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}