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.