Import external data, data includes Excel function

A

allen davidson

Hi,

I'm trying to import data from a SQL server view. The view includes an email
address [email protected]. I want this email address to be a hyperlink so I
included another column in the view with the Excel function for a hyperlink
=HYPERLINK("mailto: " & E2,"[email protected]").

The problem is that excel seems to treat =HYPERLINK("mailto: " &
E2,"[email protected]") as text rather than a function i.e the cell displays
=HYPERLINK("mailto: " & E2,"[email protected]"). If you click in and then out of
the formula bar Excel refreshes the cell to show [email protected].

Any ideas?
 
Top