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!!!
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!!!