Extract data from one cell to multiple cells.

[hungledink]

I have an email that contains data filled in from a form on the internet. This form contains 6 piecesof information, such as name, address etc.
I have a spreadsheet that imports data from this email, and it shows all the data from the email body in one cell.
Each piece of information is in the following format


Name:
Sid Wattle


Address:
Some house
Some city
Postcode


I'd like to get each of these different data sets in their own cell. So the original data is in cell A1, then the name would be in cell B2, address in C1


Can you advise the best most effecient way to do this? There's going to be approx 100 emails each with 7 fields of data.

Thanks

 

[hungledink]

Thanks for the posts everyone but someone has posted a solution on the ozgrid message board that does what I needed ?

 

[Fluff]

Thanks for letting us know, but would you mind posting the solution here?

 

[hungledink]

He came up with this formula posted in column B, with original data in column A

MID(LEFT($A2,IF(C$1="",250,FIND(C$1,$A2)-1)),FIND(B$1,$A2)+LEN(B$1)+1,250)

Does the trick.

 

[Fluff]

Many thanks