{"id":45445,"date":"2014-04-03T13:50:20","date_gmt":"2014-04-03T12:50:20","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=45445"},"modified":"2021-02-02T16:56:06","modified_gmt":"2021-02-02T15:56:06","slug":"concatenate-geeft-fout","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/concatenate-geeft-fout\/","title":{"rendered":"CONCATENATE geeft fout"},"content":{"rendered":"<p>V. Als ik in Excel probeer cellen samen te voegen met CONCATENATE krijg ik een #VALUE fout.<\/p>\n<p>A. Dat kan gebeuren als je een bereik aanduidt in plaats van individuele cellen. Helaas werken de oude probleemoplossers niet meer wegens achterhaald.<\/p>\n<p>Ik raad aan om in plaats van<\/p>\n<p>=CONCATENATE(A1:A4)<\/p>\n<p>te gebruiken:<\/p>\n<p>=A1&amp;A2&amp;A3&amp;A4<\/p>\n<p>Ofwel een eigen functie te maken. Alt+F11, module invoegen, en daarin plaatsen:<\/p>\n<p>Function samenvoegen(r As Excel.Range) As String<br \/>\nDim buffer As String<br \/>\nFor Each cell In r<br \/>\nbuffer = buffer &amp; cell<br \/>\nNext<br \/>\nsamenvoegen = buffer<br \/>\nEnd Function<\/p>\n<p>Gebruik nu de functie samenvoegen in plaats van CONCATENATE.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Als ik in Excel probeer cellen samen te voegen met CONCATENATE krijg ik een #VALUE fout. A. Dat kan gebeuren als je een bereik aanduidt in plaats van individuele cellen. Helaas werken de oude probleemoplossers niet meer wegens achterhaald. Ik raad aan om in plaats van =CONCATENATE(A1:A4) te gebruiken:<\/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":[54,375,10,246,391],"tags":[],"class_list":["post-45445","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010","category-office","category-office-2010","category-office-2013"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 11:23:07","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\/45445","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=45445"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45445\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=45445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=45445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=45445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}