Replace Multiple Cells that contains the same text

[nobodyNZ]

Hi Guys,
Is there a way to Find & Replace Multiple Cells that contains the same text.
For example:
Cell A1 contains: Brand Stanley Stock No. ASJK12311
Cell A2 contains: Brand Facom N/A 5456chis
Cell A3 contains: Brand 3M Stock No. 128931

Now, I want to replace all cells that contain the word "Stock No" to "Free Delivery"
Result should be:
Cell A1 contains: Free Delivery
Cell A2 contains: Brand Facom N/A 5456chis
Cell A3 contains: Free Delivery

I've tried a few methods but none of them work.
I'm wondering if someone here is kind enough to write an example Macro/VBA coding for this.

Thanks guys,

[jindon]

VBA?

Find/Replace

what:=*Stock No.* replacement:= Free Deliverly

Please Login or Register  to view this content.