{"id":1603,"date":"2023-11-15T13:53:32","date_gmt":"2023-11-15T13:53:32","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/"},"modified":"2023-12-06T06:17:27","modified_gmt":"2023-12-06T06:17:27","slug":"menghasilkan-huruf-acak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/","title":{"rendered":"Bagaimana cara menghasilkan huruf acak di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2774955494\"><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>Pernahkah Anda menghadapi situasi di mana Anda harus membuat huruf acak? Terkadang Anda perlu membuat huruf acak.<\/p><p> BENAR? Di Excel, Anda memiliki fungsi seperti RAND dan RANDBETWEEN untuk menghasilkan angka acak, namun kami tidak memiliki fungsi khusus untuk menghasilkan huruf.<\/p><p> Hari ini saya ingin berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan bagian terbaiknya adalah sederhana dan mudah digunakan.<\/p><h2 id=\"so-what-s-the-formula-to-generate-random-letters-in-excel\" class=\"wp-block-heading\"> Lalu bagaimana rumus menghasilkan huruf acak di excel?<\/h2><p> Seperti yang saya katakan, tidak ada fungsi langsung di Excel yang dapat membantu Anda mendapatkan huruf\/huruf acak. Namun, Anda bisa menggunakan <strong><span style=\"color: #000000;\">kombinasi RANDBETWEEN dan CHAR<\/span><\/strong> untuk membuat rumus mendapatkan huruf acak.<\/p><h2 id=\"if-you-want-to-generate-capital-random-letters\" class=\"wp-block-heading\"> Jika Anda ingin menghasilkan huruf besar acak<\/h2><p> Dalam rumus ini, Anda perlu menggunakan 65 dan 90 untuk membuat huruf acak menjadi huruf kapital. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CHAR(RANDBETWEEN(65,90))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif\" sizes=\"\" srcset=\"\" alt=\"menghasilkan huruf acak dengan huruf besar\"><\/figure><\/div><h2 id=\"or-if-you-want-to-generate-small-random-letters\" class=\"wp-block-heading\"> Atau jika Anda ingin membuat huruf kecil acak:<\/h2><p> Dalam rumus ini, Anda perlu menggunakan 97 dan 122 untuk membuat huruf acak menjadi huruf kapital. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CHAR(RANDBETWEEN(97,122))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-petites-lettres-1.gif\" sizes=\"\" srcset=\"\" alt=\"menghasilkan huruf acak dengan huruf kecil\"><\/figure><\/div><h2 id=\"how-this-formula-works\" class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Sekarang izinkan saya memberi tahu Anda bagaimana rumus ini menghasilkan huruf-huruf ini. <strong><span style=\"color: #000000;\">Pertama-tama,<\/span><\/strong> Anda perlu memahami bahwa rumus ini bekerja di dua bagian berbeda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-cette-formule-genere-des-lettres-aleatoires-1.png\" sizes=\"\" srcset=\"\" alt=\"bagaimana rumus ini menghasilkan huruf acak\"><\/figure><\/div><p> <span style=\"color: #000000;\">Pada <strong>bagian pertama<\/strong> , Anda memiliki fungsi RANDBETWEEN yang dapat menghasilkan angka acak untuk Anda.<\/span> <span style=\"color: #000000;\">Anda hanya perlu menentukan angka terendah dan angka tertinggi dan itu akan mengembalikan angka acak dari rentang tersebut.<\/span> <span style=\"color: #000000;\">Singkatnya, Anda akan mendapatkan nomor acak pada hasil rentang tersebut.<\/span> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-modifier-randbetween-1.gif\" sizes=\"\" srcset=\"\" alt=\"menghasilkan huruf acak edit randbetween\"><\/figure><\/div><p> Sekarang di <strong><span style=\"color: #000000;\">bagian kedua<\/span><\/strong> , Anda memiliki fungsi CHAR yang dapat mengembalikan karakter tertentu ketika Anda menentukan angka di dalamnya. Artinya untuk setiap karakter, ada nomor tertentu yang perlu Anda masukkan ke dalam fungsi CHAR. Dan angka 65 sampai 90 mewakili huruf besar dan 97 sampai 122 huruf kecil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-modifier-le-caractere-1.gif\" sizes=\"\" srcset=\"\" alt=\"menghasilkan huruf acak, memodifikasi karakter\"><\/figure><\/div><p> Jika Anda memasukkan 65 di CHAR maka akan menghasilkan &#8216;A&#8217; dan untuk 97 akan menghasilkan &#8216;a&#8217;.<\/p><h2 id=\"the-bottom-line-is\" class=\"wp-block-heading\"> <strong>Intinya adalah:<\/strong><\/h2><ul><li> Saat Anda menentukan salah satu rentang di atas, RANDBETWEEN mengembalikan nomor acak.<\/li><li> Dan setelah itu CHAR mengembalikan karakter untuk nomor tersebut. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-deroulantes-1.gif\" sizes=\"\" srcset=\"\" alt=\"menghasilkan huruf drop-down acak\"><\/figure><\/div><p> Itulah keseluruhan ceritanya.<\/p><h2 id=\"in-the-end\" class=\"wp-block-heading\"> Pada akhirnya,<\/h2><p> Rumus yang Anda gunakan di atas sederhana dan mudah diterapkan, tidak diragukan lagi. Penggunaan terbaik di dunia nyata dari metode ini yang saya temukan adalah Anda dapat membuat grup acak untuk peserta berdasarkan alfabet.<\/p><p> <em><strong>Apakah Anda punya metode lain untuk membuat huruf acak?<\/strong><\/em><\/p><p> Pastikan untuk membagikan pandangan Anda kepada saya di bagian komentar, saya ingin mendengar pendapat Anda dan jangan lupa untuk membagikan postingan ini ke teman-teman Anda, saya yakin mereka akan melakukannya. akan menghargai. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Dapatkan file Excelnya <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/lettres-aleatoires.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><\/div><\/div><\/div><\/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\/penyaring-horisontal\/\">Buat filter horizontal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\">Buat templat peringkat bintang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-file\/\">Dapatkan nama file di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-lembar\/\">Dapatkan nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\">Acak daftar (pengurutan acak) 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-1603","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>Bagaimana cara menghasilkan huruf acak di Excel? (2023)<\/title>\n<meta name=\"description\" content=\"Hari ini saya akan berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan, yang terbaik\" \/>\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\/menghasilkan-huruf-acak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghasilkan huruf acak di Excel? (2023)\" \/>\n<meta property=\"og:description\" content=\"Hari ini saya akan berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan, yang terbaik\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif\" \/>\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\/menghasilkan-huruf-acak\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/\",\"name\":\"Bagaimana cara menghasilkan huruf acak di Excel? (2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif\",\"datePublished\":\"2023-11-15T13:53:32+00:00\",\"dateModified\":\"2023-12-06T06:17:27+00:00\",\"description\":\"Hari ini saya akan berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan, yang terbaik\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghasilkan huruf acak 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":"Bagaimana cara menghasilkan huruf acak di Excel? (2023)","description":"Hari ini saya akan berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan, yang terbaik","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\/menghasilkan-huruf-acak\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghasilkan huruf acak di Excel? (2023)","og_description":"Hari ini saya akan berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan, yang terbaik","og_url":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif","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\/menghasilkan-huruf-acak\/","url":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/","name":"Bagaimana cara menghasilkan huruf acak di Excel? (2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif","datePublished":"2023-11-15T13:53:32+00:00","dateModified":"2023-12-06T06:17:27+00:00","description":"Hari ini saya akan berbagi dengan Anda trik rumus luar biasa untuk menghasilkan huruf acak di Excel. Dan, yang terbaik","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/generer-des-lettres-aleatoires-avec-des-majuscules-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghasilkan huruf acak 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\/1603","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=1603"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1603\/revisions"}],"predecessor-version":[{"id":2601,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1603\/revisions\/2601"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}