{"id":1603,"date":"2023-11-15T13:53:32","date_gmt":"2023-11-15T13:53:32","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/"},"modified":"2023-12-06T05:52:30","modified_gmt":"2023-12-06T05:52:30","slug":"willekeurige-letters-genereren","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/","title":{"rendered":"Hoe willekeurige letters genereren in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-853650066\"><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>Heeft u ooit een situatie meegemaakt waarin u willekeurige letters moest genereren? Soms moet je willekeurige alfabetten genereren.<\/p><p> RECHTS? In Excel heb je functies zoals RAND en RANDBETWEEN om willekeurige getallen te genereren, maar we hebben geen speciale functie om letters te genereren.<\/p><p> Vandaag wil ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En het beste is dat het eenvoudig en gemakkelijk te gebruiken is.<\/p><h2 id=\"so-what-s-the-formula-to-generate-random-letters-in-excel\" class=\"wp-block-heading\"> Dus, wat is de formule om willekeurige letters in Excel te genereren?<\/h2><p> Zoals ik al zei, is er geen directe functie in Excel die je kan helpen willekeurige letters\/alfabetten te krijgen. Maar u kunt een <strong><span style=\"color: #000000;\">combinatie van RANDBETWEEN en CHAR<\/span><\/strong> gebruiken om een formule te maken om willekeurige letters te krijgen.<\/p><h2 id=\"if-you-want-to-generate-capital-random-letters\" class=\"wp-block-heading\"> Als u willekeurige hoofdletters wilt genereren<\/h2><p> In deze formule moet je 65 en 90 gebruiken om de willekeurige letter met een hoofdletter te maken. <\/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=\"genereer willekeurige letters met hoofdletters\"><\/figure><\/div><h2 id=\"or-if-you-want-to-generate-small-random-letters\" class=\"wp-block-heading\"> Of als u kleine willekeurige letters wilt genereren:<\/h2><p> In deze formule moet je 97 en 122 gebruiken om de willekeurige letter met een hoofdletter te maken. <\/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=\"genereer willekeurige letters met kleine letters\"><\/figure><\/div><h2 id=\"how-this-formula-works\" class=\"wp-block-heading\"> Hoe werkt deze formule?<\/h2><p> Laat me je nu vertellen hoe deze formule deze letters genereert. <strong><span style=\"color: #000000;\">Allereerst<\/span><\/strong> moet u begrijpen dat deze formule in twee verschillende delen werkt. <\/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=\"hoe deze formule willekeurige letters genereert\"><\/figure><\/div><p> <span style=\"color: #000000;\">In het <strong>eerste deel<\/strong> heb je de functie RANDBETWEEN die willekeurige getallen voor je kan genereren.<\/span> <span style=\"color: #000000;\">U hoeft alleen maar het laagste en het hoogste getal op te geven en er wordt een willekeurig getal uit dat bereik geretourneerd.<\/span> <span style=\"color: #000000;\">Kortom, u krijgt een willekeurig getal in het resultaat in het bereik.<\/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=\"genereer willekeurige letters bewerk randbetween\"><\/figure><\/div><p> In het <strong><span style=\"color: #000000;\">tweede deel<\/span><\/strong> heb je nu de CHAR-functie die een specifiek teken kan retourneren als je er een getal in opgeeft. Dit betekent dat er voor elk teken een specifiek nummer is dat u in de CHAR-functie moet invoegen. En de cijfers 65 tot en met 90 vertegenwoordigen hoofdletters en 97 tot en met 122 kleine letters. <\/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=\"willekeurige letters genereren, karakter wijzigen\"><\/figure><\/div><p> Als u 65 in CHAR invoert, wordt &#8216;A&#8217; geretourneerd en voor 97 wordt &#8216;a&#8217; geretourneerd.<\/p><h2 id=\"the-bottom-line-is\" class=\"wp-block-heading\"> <strong>De conclusie is:<\/strong><\/h2><ul><li> Wanneer u een van de bovenstaande bereiken opgeeft, retourneert RANDBETWEEN een willekeurig getal.<\/li><li> En daarna retourneert CHAR een teken voor dat getal. <\/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=\"genereer willekeurige vervolgkeuzeletters\"><\/figure><\/div><p> Dat is het hele verhaal.<\/p><h2 id=\"in-the-end\" class=\"wp-block-heading\"> Aan het einde,<\/h2><p> De formule die u hierboven gebruikte is eenvoudig en gemakkelijk toe te passen, daar bestaat geen twijfel over. Het beste gebruik van deze methode in de praktijk dat ik heb ontdekt, is dat je willekeurige groepen voor deelnemers kunt genereren op basis van het alfabet.<\/p><p> <em><strong>Heeft u een andere methode om willekeurige letters te maken?<\/strong><\/em><\/p><p> Zorg ervoor dat u uw mening met mij deelt in het opmerkingengedeelte. Ik hoor graag van u en vergeet alstublieft niet dit bericht met uw vrienden te delen, ik weet zeker dat zij dat zullen doen. zal waarderen. <\/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\"> Haal het Excel-bestand op <\/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\">Downloaden<\/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\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/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\/nl\/horizontaal-filter\/\">Maak een horizontaal filter in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/sterrenwaardering\/\">Maak een sterrenbeoordelingssjabloon in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/bestandsnaam-ophalen\/\">Bestandsnaam ophalen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/bladnaam-ophalen\/\">Haal de bladnaam op in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/randomiseer-de-lijst\/\">Randomiseer een lijst (willekeurig sorteren) in 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>Hoe willekeurige letters genereren in Excel? (2023)<\/title>\n<meta name=\"description\" content=\"Vandaag zal ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En de beste\" \/>\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\/nl\/willekeurige-letters-genereren\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe willekeurige letters genereren in Excel? (2023)\" \/>\n<meta property=\"og:description\" content=\"Vandaag zal ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En de beste\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:52:30+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/\",\"name\":\"Hoe willekeurige letters genereren in Excel? (2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#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-06T05:52:30+00:00\",\"description\":\"Vandaag zal ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En de beste\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#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\/nl\/willekeurige-letters-genereren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe willekeurige letters genereren in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe willekeurige letters genereren in Excel? (2023)","description":"Vandaag zal ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En de beste","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\/nl\/willekeurige-letters-genereren\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe willekeurige letters genereren in Excel? (2023)","og_description":"Vandaag zal ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En de beste","og_url":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:52:30+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":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/","url":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/","name":"Hoe willekeurige letters genereren in Excel? (2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#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-06T05:52:30+00:00","description":"Vandaag zal ik een geweldige formuletruc met je delen om willekeurige letters in Excel te genereren. En de beste","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/willekeurige-letters-genereren\/#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\/nl\/willekeurige-letters-genereren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe willekeurige letters genereren in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1603"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1603\/revisions"}],"predecessor-version":[{"id":2906,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1603\/revisions\/2906"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}