Find part data in row range?
 

Hi. This seems so simple in my head, but I can't figure it out. I have a
sheet of data brought in from an access memo field. I've parsed the data
into rows, but it's mixed and I'm trying to get it into correct columns on a
separate sheet.

Example:
01D01 Comm. Date: 01/10/1967 Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970 Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982

I need, on the other sheet, Something like:
01D01 Comm. Date: 01/10/1967
Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970
Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982

so all commission dates are in one column, all manufacturers in another etc.
I was looking at vlookup across the row, or index or match, but can't figure
it out.

HELP!

Find part data in row range?
 

What you are saying about what you have is not clear. What do you mean when
you say your data is "mixed"? Be very specific when you describe what you
have. For instance:
I have this in A1.
I have this other in B1.
etc.
etc.

I want this in A1.
I want that in B1.
etc.
etc.
HTH Otto
"Fluke" wrote in message
...
Hi. This seems so simple in my head, but I can't figure it out. I have a
sheet of data brought in from an access memo field. I've parsed the data
into rows, but it's mixed and I'm trying to get it into correct columns on
a
separate sheet.

Example:
01D01 Comm. Date: 01/10/1967 Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970 Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982

I need, on the other sheet, Something like:
01D01 Comm. Date:
01/10/1967
Manufacturer: A.J. Riley
01D02 Comm. Date:
01/10/1970
Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982

so all commission dates are in one column, all manufacturers in another
etc.
I was looking at vlookup across the row, or index or match, but can't
figure
it out.

HELP!