{"id":57580,"date":"2020-10-22T21:55:56","date_gmt":"2020-10-22T20:55:56","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=57580"},"modified":"2020-11-08T09:57:03","modified_gmt":"2020-11-08T08:57:03","slug":"excel-alles-rij-per-rij-samen","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/excel-alles-rij-per-rij-samen\/","title":{"rendered":"Excel: alles rij per rij samen"},"content":{"rendered":"<p>V. Ik open dit bestand hier in Excel, maar alle gegevens komen in \u00e9\u00e9n cel, rij per rij<\/p>\n<p>A. Ik ga er van uit dat het over een CSV bestand gaat.<\/p>\n<ul>\n<li>Open het bestand en selecteer de gegevens<\/li>\n<li><em>Data, Text to columns<\/em>. Duid het lijstscheidingsteken aan (bv komma) aan en vraag aan Excel om te splitsen op dat lijstscheidingsteken.<\/li>\n<\/ul>\n<p>Meer info:<\/p>\n<p><em>Tekst splitsen in verschillende kolommen met de wizard Tekst naar kolommen &#8211; Excel<\/em><br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/tekst-splitsen-in-verschillende-kolommen-met-de-wizard-tekst-naar-kolommen-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/tekst-splitsen-in-verschillende-kolommen-met-de-wizard-tekst-naar-kolommen-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik open dit bestand hier in Excel, maar alle gegevens komen in \u00e9\u00e9n cel, rij per rij A. Ik ga er van uit dat het over een CSV bestand gaat. Open het bestand en selecteer de gegevens Data, Text to columns. Duid het lijstscheidingsteken aan (bv komma) aan en<\/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":[456],"class_list":["post-57580","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-odisee","category-office","category-tabellen","tag-csv"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 22:07: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\/57580","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=57580"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/57580\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=57580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=57580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=57580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}