Find and Replace dynamically

[gyj]

Hi,
I am having trouble trying to Find and Replace info based on Cell content, rather than static content.

In other words, I am trying to write a macro that can find cell content and replace it with another cells content.

Example:

Cell A2 = I like Johnny
Cell A3 = I like Johnny, Susie, and Anna.
Cell A4 = Timmy

I would like to write a macro (VBA code) that can look at the content in cell A2.
Find that same content in cell A3 that matches the content in cell A2.
Replace the content in cell A3 with the content in cell A4.

Results of cell A3, using example above would be: Timmy, Susie, and Anna.

Can this be done? I have tried every possible Excel formula, macro recording and VBA code that I know and none of it worked.

Thanks,
GYJ

[FDibbins]

VBA will probably give you what you need, but this formula will give you the same thing. however, you cant use it in A3, because it uses that cell as a reference...

=SUBSTITUTE(A3,A2,A4)