I have a huge spreadsheet that I am building to place about 10,000 products on my online shopping cart. I can create the database in excel and upload it for my entire product line but I have a question about one particular cell.

Each item has a description then in the cell next to it, there is the html of what I want the description to look like for each product when viewed online. What I want to do, since i already have all of the descriptions from my excel pricing program that I built, is to plug the descriptions into the cell containing the html.

Column U contains the descriptions. Column V contains the html code.

Example of what is in column U:
9"W x 12"D x 30"H

Example of what is in column V:
<div style="text-align: center; font-weight: bold; font-family: Garamond;"><span style="font-size: 18pt;">9"W x 12"D x 30"H Wall<br></span></div><br style="font-family: Garamond;"><span style="font-family: Garamond; font-size: 12pt;"></span>

What I want to do is replace 9"W x 12"D x 30"H Wall, which is the description in column V, with whatever is in column U but leave the rest intact.

I have used =C8&"-B2" in other parts of the sheet to copy a cell and add -B2 to it. I tried doing the same thing here, but obviously ran into problems.

Thanks in advance for any suggestions.