Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 29 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 32 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JRequest::clean() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 33 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 463 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 464 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 465 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 466 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 467 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 468 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 35 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 38 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 39 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 46 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 47 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 50 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 53 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 54 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 57 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 58 Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: Cannot modify header information - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 426 Tekst samenvoegen in Excel
Notice: Use of undefined constant add_css - assumed 'add_css' in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 49 Notice: Undefined variable: add_class in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 234

Tekst samenvoegen in Excel

Veel mensen maken nog adresbestanden aan via Excel, om ze daarna naar een database te exporteren. Excel is een prima programma om ruwe data te bewerken, en je kan als je bv een kolom Voornaam en Naam hebt , deze samenvoegen naar een nieuwe kolom bv Hele naam. Dit kan ook met adressen en huisnummers, postcodes en woonplaatsen,...

Maak een nieuw ExcelBlad aan met 2 kolommen, de eerste Voornaam en de tweede Naam, je kan ook een bestaand excelbestand met adresgegevens gebruiken, maar neem dan eerst een backup. Fouten zijn snel gebeurt en met een backup ben je veilig.

Ga naar de derde kolom en selecteer de 2de cel, naast de eerste reeks gegevens die je wilt samenvoegen.

typ volgende formule in de formulebalk: =A2&" "&B2

In de derde kolom worden de namen in dit voorbeel dan bijeen gevoegd van rij 2.

Om niet voor iedere andere rij dit te hertypen selecteer je de rechterbenedenhoek van de cel (hier David Copperfield), de cursor verandert dan in een zwart plus-teken, hou je linkermuistoets ingedrukt en sleep de grijze kader tot aan de laatste naam, dit is automatisch kopiƫren in excel.

Bureaublad achtergrond afbeeldingen

Laatste

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109

Topbedrijven

Vochtbestrijdingsbedrijf Tibas bvba

Meest bezocht

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79