Find text in a cell, and place text before it

[Gamermatt]

Hello,

I need a formula to do the following...

In column A, I have a list of titles. In column B, I have a list of phrases. In column C, I have another list of phrases.

I need a formula to put into column D, that will find the phrase from col B in col A, and then place the phrase from col C right before it.

How would I go about doing this?

Thanks,

Matt

 

[jim may]

Can you show us some sample data?

 

[Gamermatt]

Excel Workbook
	A	B	C
1	Infiniti G35 Sedan 3.5L V6 Short Ram Intake System 07 08	Short Ram Intake System	Black
2	Chevrolet Camaro SS 6.2L V8 4" Tuned Cold Air Intake w/MR Tech and Air Fusion 09 10	Cold Air Intake	Polished
Sheet1

Result:

Excel Workbook
	D
1	Infiniti G35 Sedan 3.5L V6 Black Short Ram Intake System 07 08
2	Chevrolet Camaro SS 6.2L V8 4" Tuned Polished Cold Air Intake w/MR Tech and Air Fusion 09 10
Sheet1

 

[Gamermatt]

any help with this?

 

[jim may]

Does this work for you? Copy E1 down to bottom...

Excel Workbook
	A	B	C	D	E
1	Infiniti G35 Sedan 3.5L V6 Short Ram Intake System 07 08	Short Ram Intake System	Black		Infiniti G35 Sedan 3.5L V6 Black Short Ram Intake System 07 08
2	Chevrolet Camaro SS 6.2L V8 4" Tuned Cold Air Intake w/MR Tech and Air Fusion 09 10	Cold Air Intake	Polished		Chevrolet Camaro SS 6.2L V8 4" Tuned Polished Cold Air Intake w/MR Tech and Air Fusion 09 10
Sheet1

Excel 2007

Cell Formulas
Range	Formula
E1	=REPLACE(A1,FIND(B1,A1),LEN(B1),C1 &" " &B1)

 

[Gamermatt]

Does this work for you? Copy E1 down to bottom...

Excel Workbook
	A	B	C	D	E
1	Infiniti G35 Sedan 3.5L V6 Short Ram Intake System 07 08	Short Ram Intake System	Black		Infiniti G35 Sedan 3.5L V6 Black Short Ram Intake System 07 08
2	Chevrolet Camaro SS 6.2L V8 4" Tuned Cold Air Intake w/MR Tech and Air Fusion 09 10	Cold Air Intake	Polished		Chevrolet Camaro SS 6.2L V8 4" Tuned Polished Cold Air Intake w/MR Tech and Air Fusion 09 10
Sheet1

Excel 2007

Cell Formulas
Range	Formula
E1	=REPLACE(A1,FIND(B1,A1),LEN(B1),C1 &" " &B1)

that works, thank you very much!