Hi folks, Thanks for taking the time to look and help out!
I have data coming from an SQL db and some of the fields of my report have been formatted via VBA to do things like convert email strings into actual email links, and some of the data is just plain text.
My problem is that one of the fields has imbedded HTML codes that were created by the original app and stored within that field in the SQL db. Only some of the records have the formatting but when they do, it is typically for text formatting, but occassionally to imbed links. I need to have Excel interpret these HTML codes in this one field back to the text formatting and links that they represent.
Here is an example:
<html><body>Folder to contain requirments <b>rejected</b> because they are duplicates.</body></html>
How to I get Excel 2003 (or 2007 if necessary) to convert the HTML?
If it can be "converted", can Excel interpret or view the HTML? If not, can it be stripped out?
I have looked at this in Excel 2007 and it does not automatically interpret the HTML. I have also tried exporting the whole spreadsheet to Web Page and then doing a Data/Import as per the suggestion for a similar problem someone posted. This did not work.
Thanks in advance for your ideas!
Bookmarks