Find a text/string and replace it

Hi guys, I would like to ask you, if the following is possible in excel:

I have 4 columns in which is text combined with numbers (Lorem ipsum dolor sit amet t-shirt LPW01-B consectetur adipiscing.)
I need to search every column and cells in them for a word/string which is written in R2 and replace the word in every cell by the word in S2

So for example, in R2 is "t-shirt" and in S2 is "potato"

The program finds the entry: "Lorem ipsum dolor sit amet t-shirt LPW01-B consectetur adipiscing." and replace it with "Lorem ipsum dolor sit amet potato LPW01-B consectetur adipiscing."

Do you know what I mean?
Any help will be appreciated.

Thank you.

P.S.: I am having a trouble with uploading the file directy here, so here's a link: https://www.sendspace.com/file/0fdts7

hi royalB, if data in A:D columns

Please Login or Register  to view this content.

Originally Posted by watersev

hi royalB, if data in A:D columns

Please Login or Register  to view this content.

Works absolutely gorgeous ) thank you.