excel formual

[tradecop]

Hi guys,
I am wondering in excel if there is any formula or VB any one can recommend for below scenario,
Keywordtextfirst senABC 123ABC 123 ABCabc 123 great pricingABC 123 111ABC 123 …DEF 456DER 456 ABCDER 456 Great PricingDER 456 111DER 456 …

i have thousands of items like this and what i need to do is what is in column A (keyword) is i need to replace the column B (text) and column C.
So as you can see i have the first 3 set up, then i get to the next keyword in column A so i need to replace the "ABC123" in column B and C with the new keyword out of column A.

 

[Tweak155]

It is really hard to tell what is in what column with your example.

Can you break up the example by data provided and then desired result?

Ex:

Data Given:

A(what is in column a?) B(what is in column b?) C(what is in column c?)

Result:
A(what should now be in a?) B(what should now be in b?) C(what should now be in C?)

 

[tradecop]

I will have a list of keywords in column A
Column B is the list of keywords that contain the keyword in column A.
Column c is a sentence that contain the keyword in column A

So basically I have the I have a list of the keywords for the column A and just to keep changing "just the keyword" in column b and c

Hope this makes bit more sense if not let me know and I will try post better example.

 

[Hmongkeysauce]

You'll want to use the SUBSTITUTE function in excel.