{"id":51268,"date":"2017-04-18T11:49:57","date_gmt":"2017-04-18T10:49:57","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=51268"},"modified":"2017-04-15T11:54:11","modified_gmt":"2017-04-15T10:54:11","slug":"leeftijden-van-tekst-omzetten-in-getal","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/leeftijden-van-tekst-omzetten-in-getal\/","title":{"rendered":"Leeftijden van tekst omzetten in getal"},"content":{"rendered":"<p>V. Ik heb een Excel ge\u00ebrfd met daarin leeftijden genoteerd als bv. <em>44 j\u00c2\u00a010 m<\/em>. Kan ik dat omzetten naar getallen, zodat ik kan rekenen en bv. filteren?<\/p>\n<p>A. Ja &#8211; ik zou dat doen met<\/p>\n<pre>=NUMBERVALUE(LEFT(A1;2))<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51269\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-leeftijduitgeschreven-300x94.png\" alt=\"\" width=\"300\" height=\"94\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-leeftijduitgeschreven-300x94.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-leeftijduitgeschreven.png 498w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Excel neemt dan de eerste twee tekens van die leeftijd (ik ga er van uit dat de leeftijd in twee cijfers is, of een cijfer en een spatie) en zet die om in een getal.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb een Excel ge\u00ebrfd met daarin leeftijden genoteerd als bv. 44 j\u00c2\u00a010 m. Kan ik dat omzetten naar getallen, zodat ik kan rekenen en bv. filteren? A. Ja &#8211; ik zou dat doen met =NUMBERVALUE(LEFT(A1;2)) Excel neemt dan de eerste twee tekens van die leeftijd (ik ga er<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[464,375,79,10,246,160],"tags":[],"class_list":["post-51268","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel-office-2010","category-odisee","category-office","category-office-2010","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 05:38:40","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\/51268","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=51268"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51268\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=51268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=51268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=51268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}