Trying to copy text from 4 columns into 1 column with HTML?

  • Thread starter Thread starter evolart
  • Start date Start date
E

evolart

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

You can see my spreadsheet here: 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 Char
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 b
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 "<l
type=disc> Gold Plate Charms cost $" and so on..
 
I'm really hoping this is possible, people keep viewing but not saying
anything at all. Is it not possible?
 
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!
 
Back
Top