Using Excel formula to create HTML code text referencing specific cells

gvsumich

New Member
Joined
Dec 12, 2018
Messages
2
Hello All,

I need some help! I am selling sports cards on ebay and attempting to automate a good portion of the listing process. I have a fancy pants description for each listing that uses HTML code to display my listing template.

eBay has a bulk upload process that leverages an excel file that will greatly reduce the listing time required.

So what I would like to do is to take the HTML text below and have the bold orange update based on specific cell references in an excel data table. (ie: Khris Middleton would be replaced with E3)

I've tried converting the current HTML text into a formula that references the cells but I get an error message (error with this formula). I tried just using "" and &, along with iferror but get the same error message from excel that there is an issue with the formula.

HTML CODE

<font rwr="1" size="4" style=""><div style="text-align: center; width: 100%; max-width: 1100px; margin: 0px auto; padding: 0px; border: 2px solid rgb(0, 0, 0); border-radius: 15px;"><div style="padding: 4px;"><div style="font-family: Arial; display: table; width: 100%; border-spacing: 8px;"><div style="display: table-cell; width: 60%; text-align: center; vertical-align: middle; padding: 4px; border: 1px solid #202020; border-radius: 12px;"><img src="https://pbs.twimg.com/profile_banners/1516960844701224960/1650507035/1500x500" style="width: 600px; height: 200px;"><br>

</div>

</div>

<div style="margin-right: 8px; margin-bottom: 8px; margin-left: 8px; padding: 4px; border: 1px solid rgb(32, 32, 32); border-radius: 12px;"><div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background-image: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"><span style="font-family: arial;">ITEM DETAILS</span></div>

<div style="color: rgb(24, 24, 24); text-align: left; padding: 8px;">

<p style="color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="color: rgb(24, 24, 24); font-size: medium;"><b style="font-family: arial;">Player:</b><font face="arial">&nbsp;</font><font face="Arial">Khris Middleton</font></span></p><p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;">

<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Year:</b>&nbsp;2021</span><br style="color: rgb(24, 24, 24); font-size: medium;">

<br style="color: rgb(24, 24, 24); font-size: medium;">

<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Product:</b>&nbsp;Panini Contenders Game Ticket Green Ice Parallel Card</span><br style="color: rgb(24, 24, 24); font-size: medium;">

<br style="color: rgb(24, 24, 24); font-size: medium;">

<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Card Number:</b>&nbsp;83</span></p>

</div>

<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 4px;"><span style="font-size:16px;"><span style="font-size: 16px; font-family: arial;">Item is being sold as is. We will do our best to note noticeable flaws below but please view the pictures to determine condition of the card(s).<br>

<br>

Please send us a message with any questions.<br>

<br>

No returns.</span></span></div>

<br>

<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); text-align: center; font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80));"><span style="font-family: arial;">PAYMENT</span></div>

<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;">

<p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="font-size: 16px;"><span style="background-color: rgb(255, 255, 255);">- PayPal Payments must be from a verified PayPal account.<br>

</span><br>

- "Buy It Now" listings payment is due within 7 days for single items. If purchasing more then one item please add them to your eBay cart and then combine the shipping. If you are having trouble with this simply commit to all the products and then contact us for combined shipping prior to payment.</span></p>

<p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="font-size: 16px;">- "Auction" listings must be Paid within seven days of the closing of your first item. If you have additional items closing after seven days we will combine these items for you after they close.</span></p>

<span style="font-family: arial; font-size: 16px;"><span style="font-size: 18pt;"><span style="font-size: 16px;"><span style="width: 293px; height: 16px;">- Sales tax is charged according to eBay policy.</span></span></span></span></div>

<br>

<br>

<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); text-align: center; font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80));"><span style="font-family: arial;">SHIPPING</span></div>

<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;"><span style="font-family: arial;"><span style="font-size: 12pt; text-align: center;">- Single cards sold under $20 USD ship in a Plain White Envelope with&nbsp;</span><span style="font-size: 12pt; text-align: center;">eBay standard envelope. Please be patient with the tracking as it is not always updated/scanned by UPS.<br>

<br>

</span></span><span style="font-family: arial; font-size: 16px;"><span style="font-size: 12pt; text-align: center;">-&nbsp;</span><span style="text-align: center; width: 639px; height: 17px;">Single cards sold $20 or more and card lots shipped well protected in a team bag and bubble mailer.<br>

<br>

- Ungraded cards will be sleeved in a toploader/card saver and taped with painter's tape to keep the card from falling out in transit.<br>

<br>

- We will typically ship cards within 2-3 business days of completed payment.</span></span></div>

<br>

<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background-image: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"><span style="font-family: arial;">ABOUT US</span></div>

<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;"><span style="font-family: arial;">C4 Cards was established in 2022. Just a dad and his 3 kids having a blast buying, selling, and collecting cards. We primarily focus on basketball, football and Pokemon cards but will occasionally have other sports/collectibles as well. We appreciate you checking us out and would love to earn your positive feedback! Please message us with any questions/comments/suggestions.</span></div>

</div></div>

<div style="font-family: Arial; height: 30px; text-align: center; border-top: 1px solid rgb(0, 0, 0); border-bottom-right-radius: 12px; border-bottom-left-radius: 12px; background: radial-gradient(rgb(216, 216, 216), rgb(40, 40, 40));"></div>

</div><br></font>
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top