{"id":50813,"date":"2017-02-02T17:58:05","date_gmt":"2017-02-02T16:58:05","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50813"},"modified":"2017-01-30T18:13:27","modified_gmt":"2017-01-30T17:13:27","slug":"jokertekens-om-te-zoeken-of-te-filteren-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/jokertekens-om-te-zoeken-of-te-filteren-in-excel\/","title":{"rendered":"Jokertekens om te zoeken of te filteren in Excel"},"content":{"rendered":"<p>Een Excel tip: je kan jokertekens gebruiken om gegevens (strings of, om het niet technisch te zeggen, woorden) te zoeken. Daarbij staat <em><strong>*<\/strong><\/em> voor &#8220;gelijk wat&#8221; en <em><strong>?<\/strong><\/em> voor &#8220;\u00e9\u00e9n letter (gelijke welke letter)&#8221;. Bijvoorbeeld:<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards0.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50816\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards0-123x300.png\" alt=\"\" width=\"123\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards0-123x300.png 123w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards0.png 145w\" sizes=\"auto, (max-width: 123px) 100vw, 123px\" \/><\/a><\/p>\n<p><em>Filteren<\/em> met <strong>a?a<\/strong> en <strong>a*<\/strong> geeft respectievelijk:<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1ster.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50814\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1ster-204x300.png\" alt=\"\" width=\"204\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1ster-204x300.png 204w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1ster.png 302w\" sizes=\"auto, (max-width: 204px) 100vw, 204px\" \/><\/a> <a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1vraagteken.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50815\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1vraagteken-210x300.png\" alt=\"\" width=\"210\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1vraagteken-210x300.png 210w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards1vraagteken.png 308w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p>Je kan daarmee ook <em>zoeken<\/em><\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50817\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards2-300x190.png\" alt=\"\" width=\"300\" height=\"190\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards2-300x190.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-wildcards2.png 543w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Verder moet je nog weten dat je met <strong>~*<\/strong> naar een ster kan zoeken, en met <strong>~?<\/strong> naar een vraagteken.<\/p>\n<p>Meer weten? Lees dan<\/p>\n<p><a href=\"http:\/\/spreadsheeto.com\/wildcard\/\">The 3 Best Wildcards in Excel: \u00c2\u00a0Asteriks (*), Question Mark (?), and Tilde (~)<\/a><br \/>\n<a href=\"https:\/\/support.office.com\/en-us\/article\/Find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90?ui=en-US&amp;rs=en-US&amp;ad=US\">Find or replace text and numbers on a worksheet<\/a><br \/>\n<a href=\"http:\/\/www.exceluser.com\/excel_help\/functions\/guide-to-excel-wildcards.htm\">Guide to Using Wildcards in Excel Worksheet Functions <\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Een Excel tip: je kan jokertekens gebruiken om gegevens (strings of, om het niet technisch te zeggen, woorden) te zoeken. Daarbij staat * voor &#8220;gelijk wat&#8221; en ? voor &#8220;\u00e9\u00e9n letter (gelijke welke letter)&#8221;. Bijvoorbeeld: Filteren met a?a en a* geeft respectievelijk: Je kan daarmee ook zoeken Verder moet je<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":99,"footnotes":""},"categories":[464,54,79,10,160],"tags":[],"class_list":["post-50813","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-odisee","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 21:14:10","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=50813"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50813\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}