I have this html code in column B in my spreadsheet. I am trying to replace each instance of the words 'Acorn Chain Dog Collar in Berry' with whatever text is in column A, for each row. Column A is different for every row, Column B is the same for each row.
Example:
Column A1 - Hourglass Dog Collar Poppy
Column A2 - <h1>Acorn Chain Dog Collar in Berry<br></h1><div>The <span style="font-weight: bold;"><span style="font-style: italic;">Acorn Chain Dog Collar in Berry</span></span> by Bow Wow Couture. This chic dog collar is more than just another pretty face! A unique, all cotton pet collar designed and constructed using top quality hardware, heavyweight interfacing and durable, 100% machine washable designer fabrics. Bow Wow Couture only uses curved side release buckles designed to hug your dog's neck. Thick, nickel plated D rings. The <span style="font-weight: bold; font-style: italic;">Acorn Chain Dog Collar in Berry</span> is made is super soft, gorgeous, durable, made in the USA and will look perfect on your pet! Add a matching Bow Wow Couture dog collar flower, bow tie and/or matching leash, to complete the look of the <span style="font-style: italic;"><span style="font-weight: bold;">Acorn Chain Dog Collar in Berry.</span></span></div>
Want to automatically replace "Acorn Chain Dog Collar in Berry" in B1 (and so on) with "A1" (and so on)", everwhere "Acorn Chain Dog Collar in Berry" appears. I have so many different rows of content like this that it would take way to long to do a manual search and replace for each, looking for a faster way. I have tried everything, any help would be greatly appreciated.
Thanks!!!
Bookmarks