The problem is they data from those other cells have to be put into a
certain spot within the text of the first cell. Here is the formula
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 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 $"&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
------------------------------------------------------------------------
evolart's Profile:
http://www.excelforum.com/member.php...o&userid=28129
View this thread:
http://www.excelforum.com/showthread...hreadid=476514