I am running Excel 2007. HTML tags show up in output when data is imported into Excel. Is there a setting which can be set to interpret text so this will not happen?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
Example of output that is displayed in Excel:
<TABLE style="WIDTH: 426pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0><COLGROUP><COL style="WIDTH: 426pt; mso-width-source: userset; mso-width-alt: 20772" width=568><TBODY><TR style="HEIGHT: 102pt" height=136><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 426pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 102pt; BACKGROUND-COLOR: transparent" width=568 height=136><DIV><SPAN class=260222916-06082008><FONT face=Arial size=2>Incorrect URL was sent out for accessing BSIU screens. HTTPS:// before the web address was mistakenly put in as HTTP:// <BR>
Correct address is <A title=blocked::https://www.prod.dss.mo.gov/zbrq href="https://www.prod.dss.mo.gov/zbrq"><FONT face=Arial color=#0000ff size=2>https://www.prod.dss.mo.gov/zbrq</FONT></A> Caller was typing a period at the end. I had her remove the period and she connected to the site.</FONT></SPAN></DIV></TD></TR></TBODY></TABLE>
<o
Example of output that is displayed in Excel:
<TABLE style="WIDTH: 426pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0><COLGROUP><COL style="WIDTH: 426pt; mso-width-source: userset; mso-width-alt: 20772" width=568><TBODY><TR style="HEIGHT: 102pt" height=136><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 426pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 102pt; BACKGROUND-COLOR: transparent" width=568 height=136><DIV><SPAN class=260222916-06082008><FONT face=Arial size=2>Incorrect URL was sent out for accessing BSIU screens. HTTPS:// before the web address was mistakenly put in as HTTP:// <BR>
Correct address is <A title=blocked::https://www.prod.dss.mo.gov/zbrq href="https://www.prod.dss.mo.gov/zbrq"><FONT face=Arial color=#0000ff size=2>https://www.prod.dss.mo.gov/zbrq</FONT></A> Caller was typing a period at the end. I had her remove the period and she connected to the site.</FONT></SPAN></DIV></TD></TR></TBODY></TABLE>