Excel Find string

I need to be able to search for a specific string in excel? and save that string displayed in different fields. ## Deliverables A single column contains a report in every row. Reports can be up to 10 pages of text. ? I need the following information extracted from the reports and put into rows: 201500Z MAR 08 ? ? ? ? ? ? DATE A-AAA-1234-5678 ? ? ? ? ? ? ? Report Number Report about fishing? ? ? ? ? ? ? ? ? Subject MRP0001;MRP0002;MRP0003.? ? ? ? ? ? Report Codes Output on sheet2 Report Number, Subject, DATE, Report Codes1, Report Codes2, Report Codes3, Report Codes4, Report Codes5, Report Codes6, . . . Up to 20 report codes.