Hi,
This is my first time posting to the forum. I've searched many threads here an have not found the answer I need.
I am trying to build a spreadsheet based on data extracted from my SQL Server.
What I have is a spreadsheet that is linked to a SQL View. The view contains several columns which are straight forward and not formatted when I pull the data into Excel (i.e. Ticket #, User Name, Date Created, etc.). However, the important column that contains the details of the support case is HTML formatted. So the data in that column appears something like this:
"<div>Jim</div>
<div>there were double receipts*in GP on*8/6</div>
<div>I need to get them reversed.</div></div>"
What I would like to see is:
"Jim there were double receipts in GP on 8/6 I need to get them reversed."
I just need that one column converted. I've tried everything I could think of and similar suggestions I've searched, but no luck.
I can send more detail and examples if necessary.
I appreciate any help provided.
JL
Bookmarks