{"id":52646,"date":"2018-04-06T08:29:41","date_gmt":"2018-04-06T07:29:41","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=52646"},"modified":"2018-04-06T09:36:58","modified_gmt":"2018-04-06T08:36:58","slug":"formule-om-tekst-samen-te-voegen-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/formule-om-tekst-samen-te-voegen-in-excel\/","title":{"rendered":"Formule om tekst samen te voegen in Excel"},"content":{"rendered":"<p>V. Ik zoek een manier om tekst van verschillende samen te voegen, maar blijkbaar heeft Excel geen concatenatie functie. Of toch? Is er een manier om de cellen van J3 tot N3 samen te voegen?<\/p>\n<p>A. Jawel &#8211; er is <a href=\"https:\/\/support.office.com\/en-us\/article\/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d\">CONCATENATE<\/a> (in het Nederlands <a href=\"https:\/\/support.office.com\/nl-nl\/article\/tekst-samenvoegen-functie-8f8ae884-2ca8-4f7a-b093-75d702bea31d\">TEKST.SAMENVOEGEN<\/a>). Twee bedenkingen:<\/p>\n<ul>\n<li>De <a href=\"https:\/\/support.office.com\/nl-nl\/article\/tekst-samenvoegen-functie-8f8ae884-2ca8-4f7a-b093-75d702bea31d\">helpfunctie<\/a> raadt aan TEKST.SAMENV te gebruiken &#8211; testen dus welke van de twee functies het doet.<\/li>\n<li>Celbereiken worden niet aanvaard\n<pre>(J3:N3)<\/pre>\n<p>je moet de cellen opsommen<\/p>\n<pre>(J3;K3;L3;M3;N3)<\/pre>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-52647\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/04\/xl-concatenate-300x42.png\" alt=\"\" width=\"300\" height=\"42\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/04\/xl-concatenate-300x42.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/04\/xl-concatenate.png 302w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Mijn advies: gebruik de &amp; operator<\/p>\n<pre>=J3&amp;K3&amp;L3&amp;M3&amp;N3<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik zoek een manier om tekst van verschillende samen te voegen, maar blijkbaar heeft Excel geen concatenatie functie. Of toch? Is er een manier om de cellen van J3 tot N3 samen te voegen? A. Jawel &#8211; er is CONCATENATE (in het Nederlands TEKST.SAMENVOEGEN). Twee bedenkingen: De helpfunctie raadt<\/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,54,79,10,160],"tags":[],"class_list":["post-52646","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-01 19:47:54","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\/52646","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=52646"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/52646\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=52646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=52646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=52646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}