Separating different lines from a single Excel Cell

[Softsurf105]

I have cells that look like the one below that contain "Class C Part#:", "Manufacturer", "Mfr. Part #", "Pack code" and "your price". I'm wanting to separate the Manufacturer into once cell and the Mfr. Part # into a different cell. I have about 2,000 of these that I need to do and none of them are the same manufacturer and there are different lengths in the part #.

Class C Part #:29 Manufacturer:CAR-PAK MANUFACTURING COMPANY Mfr. Part #:95-7376 Pack Code - Qty:25 - PK Your Price (USD):TBD

<tbody>
</tbody>

 

[Scott Huish]

Here you go:

Excel 2010
	A	B	C
1	Class C Part #:29 Manufacturer:CAR-PAK MANUFACTURING COMPANY Mfr. Part #:95-7376 Pack Code - Qty:25 - PK Your Price (USD):TBD	Manufacturer:CAR-PAK MANUFACTURING COMPANY	Mfr. Part #:95-7376
Sheet1

Cell Formulas
Range	Formula
B1	=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("Manufacturer",A1),255),CHAR(10),REPT(" ",255)),255))
C1	=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("Mfr. Part #",A1),255),CHAR(10),REPT(" ",255)),255))