Html in excel

Yusei409

New Member
Joined
Nov 30, 2017
Messages
1
Hi,
so im using excel to make bulk update using a pre-existing template in which one of the columns contain a HTML code.
that html contain a specific url for an image that i would like to be able to change in bulk.
for example:
A2 contains :https://res.cloudinary.com/realgoodeal/image/upload/v1510872215/SPWA/SPWA-EN004-SECRET-1ST.jpg
B2 contains:
HTML:
PaymentAll orders are shipped within 1-2 business days after full payment is received. Please ensure that your eBay & PayPal addresses match correctly and are up to date. REAGOODEAL uses USPS, UPS, FEDEX services to ship.Shipping Options:Single Cards Only

Domestic Shipping Options (United States Only)
 
 First Class Mail Envelope (about 3-7 days, no tracking): FREE SHIPPING 
 
 First Class Mail Bubble Envelope w/Delivery Confirmation (about 3-5 days): $1.50
 
 US Priority Mail w/Delivery Confirmation (about 2-5 days): $7.95
 
 USPS Overnight Express Mail (For A.M. Order before 2 PM EST): $24.95
 
Combining multiple auction winnings:We combine shipping charges for multiple auction winnings that fall within 1 day of each other. Reminder messages are automatically sent through our invoicing system for payments outstanding.***ATTENTION INTERNATIONAL CUSTOMERS***In order to match the shipping cost please request an invoice
 
 Customers of eBay must checkout!
 
 Realgoodeal is not responsible for any International customs, taxes, fees, etc. It’s the buyer’s full responsibility. If you have a request, please contact us before ordering. 
Thank you for choosing us

i would like to replace https://res.cloudinary.com/realgoodeal/image/upload/v1509481270/MP17-1ST/MP17-EN001-Common-1st.jpg
with A2 please take into consideration that the url length may change.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,021
Latest member
Justyna P

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