{"id":55429,"date":"2019-12-05T11:06:44","date_gmt":"2019-12-05T10:06:44","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=55429"},"modified":"2019-12-05T11:06:44","modified_gmt":"2019-12-05T10:06:44","slug":"spaties-opruimen-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/spaties-opruimen-in-excel\/","title":{"rendered":"Spaties opruimen in Excel"},"content":{"rendered":"<p>Soms kan je behoorlijk last hebben van overtollige spaties, met name de onzichtbare spaties achteraan de inhoud van een cel. ALS en afgeleide functies, zoekfuncties enz. geven onverwachte resultaten, en je ziet dubbels in draaitabellen.<\/p>\n<p>Je kan die spaties opruimen met een aantal functies<\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/TRIM-function-410388FA-C5DF-49C6-B16C-9E5630B479F9\">TRIM<\/a> (en) of <a href=\"https:\/\/support.office.com\/nl-nl\/article\/spaties-wissen-functie-410388fa-c5df-49c6-b16c-9e5630b479f9?ui=nl-NL&amp;rs=nl-NL&amp;ad=NL\">SPATIES.WISSEN<\/a> (nl) voor overtollige spaties achteraan<\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/CLEAN-function-26F3D7C5-475F-4A9C-90E5-4B8BA987BA41\">CLEAN<\/a> (en) of <a href=\"https:\/\/support.office.com\/nl-nl\/article\/wissen-control-functie-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41?ui=nl-NL&amp;rs=nl-NL&amp;ad=NL\">WISSEN.CONTROL<\/a> (nl) voor overtollige tekens binnenin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Soms kan je behoorlijk last hebben van overtollige spaties, met name de onzichtbare spaties achteraan de inhoud van een cel. ALS en afgeleide functies, zoekfuncties enz. geven onverwachte resultaten, en je ziet dubbels in draaitabellen. Je kan die spaties opruimen met een aantal functies TRIM (en) of SPATIES.WISSEN (nl) voor<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[375,10,160],"tags":[],"class_list":["post-55429","post","type-post","status-publish","format-standard","hentry","category-excel-office-2010","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 14:09:53","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\/55429","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=55429"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/55429\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=55429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=55429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=55429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}