I have four columns of data which I need to grab data from and have them
entered into specific parts of html which is in a fifth column. Is this
at all possible?

You can see my spreadsheet he http://www.savefile.com/files/2459107

Listed below is the html from the field I need the data entered in:

<font size=""2"" color=""#000066"" face=""comic sans ms""
<ul
<li type=disc These charms are part of the Rembrandt Charm
Collection.
<li type=disc All Rembrandt Charms are available in Sterling Silver,
Gold Plate, 10K Yellow

Gold, 14K Yellow Gold or 14K White Gold.
<li type=disc Please choose type of metal when ordering. Cost will be
calculated at chheckout.
<li type=disc Price shown is for sterling silver charm.
<li type=disc Gold Plate Charms cost $
<li type=disc 10K Gold Charms cost $
<li type=disc 14K Yellow Gold Charms cost $
<li type=disc 14K White Gold Charms cost $
<li type=disc This charm measures "" high.
<li type=disc Measurements are approximate.
<li type=disc All Rembrandt Charms come with Lifetime warranty.
</ul"


For example cell I2 has the value I need to be placed after "<li
type=disc Gold Plate Charms cost $" and so on...


--
evolart
------------------------------------------------------------------------
evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129
View this thread: http://www.excelforum.com/showthread...hreadid=476452

I need to do this for 6,000 entries, is it possible to automate this?


--
evolart
------------------------------------------------------------------------
evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129
View this thread: http://www.excelforum.com/showthread...hreadid=476452

I'm really hoping this is possible, people keep viewing but not saying
anything at all. Is it not possible?


--
evolart
------------------------------------------------------------------------
evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129
View this thread: http://www.excelforum.com/showthread...hreadid=476452

I figured it out! Very complex and had to be broken up into 5 cells and
then all conctenated together and then the cell had to be copied and
pasted-special value only. Way better then typing it all in manually
though. I will explain in more detail and give an example spreadsheet
in case anyone ever has a similar problem! Thanks everyone!


--
evolart
------------------------------------------------------------------------
evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129
View this thread: http://www.excelforum.com/showthread...hreadid=476452