View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default 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.