HTML in cell appears as text
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.
--
Allllen
"Philippe" wrote:
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.
|