Functions from a Data Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe H - 31 Jan 2008 17:35 GMT

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.

Reply to this Message

FloMM2 - 02 Feb 2008 21:26 GMT

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

:-)

> I store Function in a table such as:
> =HYPERLINK("www.google.com","Google")
[quoted text clipped - 4 lines]
> Instead, I want it to actually be the Excel function and only the work
> "Google" would show up as a hyperlink.

Reply to this Message