USING Excel 2000.
I have a text file that when viewed in excel lists the entire row of data in
one cell. I cannot parse data because each line does not have the same
break. I want to extract the fields into individual cells. I will need to
define "what" I am looking for. Is there sample vba code for excel I can
reference to learn how this may be done?

sample report

REF #:A1B CUSIP:12345678
TD:1/1/00 SYMBOL:ABC QTY: 1
SD:01/03/00 ACME COMPANY PRICE: 9.101
MKT:OTC


want to extract

REF# TD SD CUSIP MKT SYMBOL FIELD1 QTY
PRICE PRICE
A1B 1/1/00 1/3/00 12345678 OTC ABC ACME COMPANY 1
9.101