Replace Part of a Text String With Value from Adjacent Array

[pebarry]

Hello!!

I have one column of text values. Each value I need replaced has ">" in-between each string I need replaced. It looks like (begins in cell A1 and goes on for approx 5,00 rows; each line is different):

PST - Out of Market - Brand - Exact > PST - Out of Market - Brand - Exact > PST - Out of Market - Brand - Exact > PST - Out of Market - Brand - Exact
St Louis - In Market - PST - Brand - Exact > St Louis - In Market - PST - Brand - Exact > St Louis - In Market - PST - Brand - Exact
RN-BSN - All Markets - Nonbrand - Phrase > RN-BSN - All Markets - Nonbrand - Phrase > RN-BSN - All Markets - Nonbrand - Phrase



I have an array with each text string I want replaced:
Text String (cell c1) Replace With (cell d1)
PST - Out of Market - Brand - Exact Brand
St Louis - In Market - PST - Brand - Exact In Market brand
RN-BSN - All Markets - Nonbrand - Phrase NonBrand

Does anyone have a formula I can use to make this easy?

Thanks!!!

 

[pebarry]

My thread got unformatted.

Text String in Cell C1: PST - Out of Market - Brand - Exact
Replace with in cell D1: Brand

Text String in cell C1: St Louis - In Market - PST - Brand - Exact
Replace with in cell D1: In market Brand