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?
|