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

[evolart]

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 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 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. I need to do this for
6,000 entries, is it possible to automate this?

 

[evolart]

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

 

[Anne Troy]

It would take me a bit to figure out how to accomplish what you need most
efficiently. I imagine others feel the same way. The easiest way is to
provide a before and after. My first thought is that I would probably try to
do this using mail merge with Word.
************
Anne Troy
www.OfficeArticles.com

 

[Paul]

Have you looked at the CONCATENATE function. Adding a space between each
cell-----

=CONCATENATE(A1," ",B1," ",C1," ",D1)

That way you don't even have to have adjacent cells.

 

[evolart]

The problem is they data from those other cells have to be put into
certain spot within the text of the first cell. Here is the formul
that I've come up with but it is too long for excel to use:

="<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 $"&I20&"
<li type=disc> 10K Gold Charms cost $"&J20&"
<li type=disc> 14K Yellow Gold Charms cost $"&K20&"
<li type=disc> 14K White Gold Charms cost $"&L20&"
<li type=disc> This charm measures " high.
<li type=disc> Measurements are approximate.
<li type=disc> All Rembrandt Charms come with Lifetime warranty.
</ul>"



I'm using excel 2003 btw

 

[evolart]

Have you looked at the CONCATENATE function. Adding a space between
each
cell-----

=CONCATENATE(A1," ",B1," ",C1," ",D1)

That way you don't even have to have adjacent cells.

Maybe I could use the method i was trying and then combine like 4 cells
into one using concatenate. I will have to try that....lots of work
though. It might be just as time consuming as doing it manually if I
have to break up the html into like 5 cells and then conctenate all of
them together.

Will concatenate give me the formulas or just the results? If it passes
the formulas that wont work.

 

[Anne Troy]

Concatenate will string together the formula results, but it won't format
them for you.
************
Anne Troy
www.OfficeArticles.com

 

[evolart]

I'm gonna try a couple things and post back. I hope someone has another
idea if what I'm trying doesn't work

 

[evolart]

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!