Pull form-related data from column A in Google sheets and populate columns b,C,D and E with specific data

I want to able to specify data from Column A to be populated to columns B, C, D and E.

The data in column A looks like this: Name: John LastName: Doe Mejladress: john.doe@madpeople.com Company: Mad People

How do I do this? Thanks!

I tried this to extract the mail address: =REGEXEXTRACT(A2,"Mejladress: (.+)")

And got an error even on that. So not thinking my chances of populating the others are high either.

You may try:

=index(ifna(trim(regexextract(A2,"Name:(.*)LastName:(.*)Mejladress:(.*)Company:(.*)"))))

if you wish to try each part individually, go with:

=REGEXEXTRACT(A2,"Mejladress: (.*?) ")