Copying certain values from one cell (not the value from the entire cell) into other cells

See if the attached helps. I changed your coulmn headings slightly

Try this in B2, Drag across to F2, then Down

Formula:

Please Login or Register  to view this content.

Add headers as required.

Hi Marcol,

Thanks for the quick reply!
This is exactly what I need. But when I copy this formule in my final document (with 1000 rows), with exactly the same columns and labels, it's not working for the column "Familienaam".
He gives #VALUE! Other columns are fine.

These problems are notoriously difficult to find a "Universal" solution for.
In your case the principal character to split the data on is CHAR(10), carriage return.

On that basis I would introduce a helper column substituting CHAR(10) with "|"
this allows us to search for "|" & your required category header, this helps when we have situations like
Bedrijfsnaam: & Naam:

Once we have extracted all the characters after, say "|Naam:" we can replace the second instance of "|" with a string of spaces.

Then TRIM() & Mid() will give us the desired line of information.

We can now use SUBSTITUTE() to remove the line headers.

See this workbook, add or change any header you need.

In C2 drag across then down

Formula:

Please Login or Register  to view this content.

Happy to have helped ...