Functions from a Data Source

  • Thread starter Thread starter Joe H
  • Start date Start date
J

Joe H

I store Function in a table such as:
=HYPERLINK("www.google.com","Google")

But when I connect to the data source and display it - it actually displays:
"=HYPERLINK("www.google.com","Google")"

Instead, I want it to actually be the Excel function and only the work
"Google" would show up as a hyperlink.
 
Joe,
Try this:
In the cell that you want the hyperlink (C4).
Select C4.
Select "Insert".
Select "Hyperlink".
In the box Text to display:Google
In the Address: www.google.com
hth
:-)
 
Back
Top