Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Hyperlink Length | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
How can I extract hyperlink value | Excel Discussion (Misc queries) |