ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can excel display HTML in cells (https://www.excelbanter.com/excel-discussion-misc-queries/122981-can-excel-display-html-cells.html)

AdamWaller

Can excel display HTML in cells
 
I am pulling HTML directly from a database and pasting into a cell. I want
excel to display whatever is in the cells as it would on a webpage (ie strip
the tags off and display as the tags say to display). The HTML tags are very
basic.

I am using office 2003

Can this be done?

Dave Miller

Can excel display HTML in cells
 
Adam,

Just save the data as an HTML file and open that HTML file with Excel.
Excel is pretty good at reading HTML formatting.

Dave


AdamWaller

Can excel display HTML in cells
 
The problem with that is that there is other information on the page and the
method you mentioned doent work too well with that extra data. I was hoping
you could format a single cell to tell it what is contained within that cell
is html as you can do for dates/times etc...

"Dave Miller" wrote:

Adam,

Just save the data as an HTML file and open that HTML file with Excel.
Excel is pretty good at reading HTML formatting.

Dave




All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com