View Single Post
  #1   Report Post  
rabbit ribbit
 
Posts: n/a
Default evaluate HYPERLINK()

I use Microsoft Query to query a database and return data back to excel. One
column returned contains data for hyperlinks. In SQL, the column returns a
text string '=HYPERLINK("http://www.microsoft.com", "MSFT")'. Instead of
displaying "MSFT" in the excel cell, the whole string (i.e.
"=HYPERLINK(....)") is displayed.

Is there a way to force evaluation of the string contained in a cell?