Excel 2007 : How to replace a word/string from a cell that contain a string from another cell

[mike4uuu]

Hi!

I'm looking for a solution to this ! Will be very happy if you guys can sort this out !


As the title says, i want to replace a word/string from a cell that contain a string from another cell!

Example!

Column A contains many words including [img:1orcqvu5] and column B contains only : 1orcqvu5

Similarly
Next Row - Column A contains many words including [img:x2d63ybp] and column B contains only : x2d63ybp

And so on ....


Is there any program by which i can replace

all the [img:1orcqvu5] /[img:x2d63ybp] / .... /..... / so on from column A to just [img] or to something else !

I have attached a sample file, will be grateful if somebody can solve this issue !


Thanks!