formula/macro to mimic html-formatting from one cell to another

[JCrowell]

Sorry if this is a repeat question... what I'm trying to do is the following...

If I manually html-format the text in a cell, I want to know if there's a macro/formula/tool for Excel that I can apply that will mimic the html formatting in that first cell, and convert plain text in another cell to also be html-formatted text.

In other words, I have various cells that will have text in them that will need to be html-formatted text. I want to manually html-code the first cell, then be able to copy/paste and apply to other cells with plain text, so that they will also have similar html-coded text.

Any help would be appreciated!

thanks!

 

[pbornemeier]

Please provide a few examples of the html formatting you will apply.

 

[JCrowell]

Please provide a few examples of the html formatting you will apply.

Thanks for getting back to me... for sure...

Here is the html formatted text from a cell that I'm working with:

[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64"]<p><strong>LGI Technology: LED MR16 LEDPro</strong><br><br>The new LED MR16 lamp from LGI. This new lamp was designed with energy saving in mind, producing more lumens than any of its predecessors. It produces light identical to a traditional MR16 with a similar size.</p>
<p>Â </p>
<h4>Specifications</h4>
<br><strong>Features and Benefits:</strong><br>
<ul>
<ul>
<li>Lumen Output: 520</li>
<li>Consumption (in Watts): 7</li>
<li>Direct Voltage : 12V</li>
<li>Driver Included : Built-in</li>
<li>LED Chips: CREE</li>
<li>25,000 Hours : Long Life will reduce maintenance cost</li>
<li>Energy saving : Replaces 50W Halogen MR16</li>
<li>5 Year Warranty : Guaranteed to last 5 years</li>
<li>UL Certified: UL Certified</li>
<li>Energy Star Certified : 3000k Model only</li>
<li>Color Temperature : 3000K and 5000K</li>
</ul>
</ul>
<br><strong>Commercial:</strong><br>
<ul>
<li>Residential</li>
<li>Commercial</li>
<li>Retail</li>
</ul>

So, bold header, 1-2 paragraphs of description, 2 <h4> codings to produce 2 separate "tabs," and more bulleted text

What I'm trying to do is to just be able to copy/paste regular, unformatted text into a cell, apply a macro or formula, and have it html code the text following the same pattern above... does that make sense? Any help would be appreciated! Thanks!


[/TD]
[/TR]
</tbody>[/TABLE]

 

[JCrowell]

Sorry... had that all pasted out in html... it actually posted it in rich format! let me see...

"<p><strong>LGI Technology: LED GU10 NeroLume</strong><br><br>Introducing the all new LED GU10 NeroLume from LGI. This new lamp is designed to save more energy and produce more lumens than any of its predecessors. Looks identical to a traditional MR16 with a similar size. 7W/120V/400 Lum.</p><p>Â </p>
<h4>Specifications</h4>
<br><strong>Features and Benefits:</strong><br>
<ul>
<ul>
<li>Lumen Output: 400</li>
<li>Consumption (in Watts): 7</li>
<li>Direct Voltage : 120V</li>
<li>Driver Included : Built-in</li>
<li>LED Chips: CREE</li>
<li>25,000 Hours : Long Life will reduce maintenance cost</li>
<li>Energy saving : Replaces 50W Halogen MR16</li>
<li>5 Year Warranty : Guaranteed to last 5 years</li>
<li>Color Temperature : 3000K</li>
</ul>
</ul>
<br><strong>Commercial:</strong><br>
<ul>
<li>Residential</li>
<li>Commercial</li>
<li>Retail</li>
</ul>"

 

[JCrowell]

Sorry... not sure how to post the html code without it posting in rich, formatted text

 

[pbornemeier]

Try wrapping the HTML with noparse tags:

[noparse]
html code
[/noparse]

 

[JCrowell]

Try wrapping the HTML with noparse tags:

[noparse]
html code
[/noparse]

Will try that... thanks, Phil... will let you know if that works

 

[JCrowell]

[/COLOR]
<p><strong>Header in BOLD</strong><br><br>Product description, one or more paragraphs.</p>
<p>Â </p>
<h4>Specifications tab</h4>
<br><strong>Features and Benefits and/or Specifications Bulleted List(s)</strong><br>
<ul>
<li>Bullet Point</li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
</ul>
<br><strong style="line-height: 1.5;">Bold:</strong><br>
<ul>
<li>Bullet point, etc.</li>
<li><span>Bullet point, etc.</span></li>
<li><span>Bullet point, etc.</span></li>
<li><span>Bullet point, etc.</span></li>
</ul>
[COLOR=#333333]

 

[JCrowell]

no parse<p><strong>Header in BOLD</strong><br><br>Product description, one or more paragraphs.</p>
<p>Â </p>
<h4>Specifications tab</h4>
<br><strong>Features and Benefits and/or Specifications Bulleted List(s)</strong><br>
<ul>
<li>Bullet Point</li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
</ul>
<br><strong style="line-height: 1.5;">Bold:</strong><br>
<ul>
<li>Bullet point, etc.</li>
<li><span>Bullet point, etc.</span></li>
<li><span>Bullet point, etc.</span></li>
<li><span>Bullet point, etc.</span></li>
</ul>/noparse

 

[JCrowell]

<noparse><p><strong>Header in BOLD</strong><br><br>Product description, one or more paragraphs.</p>
<p>Â </p>
<h4>Specifications tab</h4>
<br><strong>Features and Benefits and/or Specifications Bulleted List(s)</strong><br>
<ul>
<li>Bullet Point</li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
<li><span>Bullet Point</span></li>
</ul>
<br><strong style="line-height: 1.5;">Bold:</strong><br>
<ul>
<li>Bullet point, etc.</li>
<li><span>Bullet point, etc.</span></li>
<li><span>Bullet point, etc.</span></li>
<li><span>Bullet point, etc.</span></li>
</ul></noparse>