HTML in cell appears as text

G

Guest

I'm generating an excel worksheet from an external application, some data
that I need to insert in it contain html tags such as bold, underline,
colors, line breaks, etc.
How can I make this data rendered "as html" in excel instead of all tags
appearing as plain text ?

data sample: this is my data in <B> bold </B>

Philippe.
 
G

Guest

Here's the way I have found.
Save the data from the application as a .htm file.
Open the .htm file in Excel. The formatting is processed correctly now.
Use Data > text to columns if necessary.
Then save it as a workbook .xls file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top