Convert excel cell into HTML

Question

Hi Everyone

Is there a way to convert an excel cell into HTML. I'm currently copying each cell into an online HTML editor and this is quite time consuming. Is there a formula I can use in excel that will do the same thing for multiple cells or if not another programme I can use that will convert these.

Thanks in advance for your help. :)

Answer 1

Thanks HansV for your answer, this is not however the solution I was looking for. 

I want to convert text to html in an excel cell, is this possible?

For example

TURN THIS

A trio of sweet delights. Sweet sensation in one beautiful box. This should be in every family's pantry - a little decadence to make all desserts shine.

Includes:

1 x Strawberry Chocolate Sauce with 1% French Champagne 

1 x Salted Caramel Dessert Sauce 

1 x Butterscotch/Brandy Dessert Sauce

INTO THIS...

<p>A trio of sweet delights. Sweet sensation in one beautiful box. This should be in every family's pantry - a little decadence to make all desserts shine.</p><p>Includes:</p><p>1 x Strawberry Chocolate Sauce with 1% French Champagne </p><p>1 x Salted Caramel Dessert Sauce </p><p>1 x Butterscotch/Brandy Dessert Sauce </p>

Answer 2

You can save a workbook or worksheet as an Excel file:

• Press F12 to display the Save As dialog.
• Select 'Web page (*.htm; *.html)' from the 'Save as type' dropdown.
• Specify whether you want to save the entire workbook or only the currently selected sheet (or range).
• Specify a location and file name, then click Save.

Warning: this saves a lot more than just what you see.