Split text in a cell

Hello Forum,

I have a spreadsheet with a few thousand rows of information in one column as shown below,i am trying to split the information and return in separate cells so i will have 5 columns Name,POSTCODE,E:MAIL ADDRESS,TELEPHONE and CAMERA CLUB/PHOTO SOCIETY/FEDERATION.
The information is variable ,ie NAME could be 20 characters,but the information required is the same in all cells.

NAME: Dave Smith POSTCODE: ABC 123 E:MAIL ADDRESS: myaddress@home.com TELEPHONE: 01234567890 CAMERA CLUB/PHOTO SOCIETY/FEDERATION: London


Would appreciate any help.

Doug

Attachment as requested,this is just a few rows.

Doug

This is what im trying to achieve

The attached file shows how you can do that. It might be better to have the formulae in another sheet.

Hope this helps.

Pete

ok here is the actual sheet i need to populate from column "A"

Really appreciate your help here.

Doug

Okay, a few Insert Cells, then Delete cells in my file to get the formulae in the same relative place, and then just copy into row 2 of your latest file, and there you have it.

Hope this helps.

Pete

Perfect,really appreciate your help.

Many thanks

Doug