Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
When running a SAP report Excel will only display results if Excel isn't already open | Excel Discussion (Misc queries) | |||
How do I display shading of cells on the Web in Excel? | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) |