Export to CSV works fine, how do I embed a hyperlink?

[Randy Jackson]

Hello,

 

I'm working on a project where I need to export the results of a query to an Excel csv file.  That part works fine, but one thing I would like to do is embed a hyperlink in the first column that goes to another report on the server for more detail.

 

I've tried using HTML, but all I get is the actual anchor tag code, not an embedded link.  Ideally, I'm looking for something like this:

 

<a href="http://www.google.com">Google</a>

 

Is there a way to format this string so that it appears as a clickable link in Excel?  Is this even possible?