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 (e-mail address removed). 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,"(e-mail address removed)").

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

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell interpreted as mailto 5
Can UDF return a customized hyperlink? 3
How to convert imported Access Hyperlinks to Excel and KEEP the li 0
Excel - Wich Function should I use? 1
Function in Excel to count and list number of entries of text valuesin a row. 2
Can't make hyperlink function work for hyperlink to website 15
Working with XML data and functions 0
If function..please help 1

Top