Hyperlinks

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

I am using Excel to run a query against a SQL database.

One of the colums that is being returned is a web site
address (e.g., http://www.mywebsite.com)

Is there any way to format the column so that the data
being returned becomes a live hyperlink rather than just a
text string of the web site address?

Thanks
..
 
There is a worksheet function called hyperlink.

if the cell B1 contains the value:
=Hyperlink("http://www.mywebsite.com")

It will be a link.

So to get the whole column as a link, you would have to
structure your SQL query so that you get back the result
in the format:
=Hyperlink("http://www.mywebsite.com")

If the query is automatic and you cant change the format
in which the results come, I would suggest that you just
have another column with a formula using the Hyperlink
function.

For eg: if column B has your URLs, then, say in, column F
you could have a formula where
F1 =Hyperlink(B1)
F2 =Hyperlink(B2)
and so on...

Hope that helps.

Sanjay V
Sanjayva at yahoo dot com
 
Sanjay Valiyaveettil said:
There is a worksheet function called hyperlink.

if the cell B1 contains the value:
=Hyperlink("http://www.mywebsite.com")

It will be a link.

So to get the whole column as a link, you would have to
structure your SQL query so that you get back the result
in the format:
=Hyperlink("http://www.mywebsite.com")
Click to expand...

How would this work? The query results would be interpreted as text
(e.g. a leading apostrophe would be added). How would it be recognized
as a formula?

Jamie.

--
 
Back
Top