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

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!

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this.