Re. Internet links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candyman - 06 Jul 2004 18:44 GMT

Hi!

Sorry if this is been seen twice by some people - I did
not see this option for links!!

I have been given a database of names, addresses and
website addresses in an Excel spreadsheet. The website
addresses do not appear as a hyperlink. Is there anyway
to Format that row to make all of the addresses appear as
links that I can click on that will then just direct my
browser to that website. This works fine if I input data
from scratch with www as a prefix but not with existing
data.
I am using Office 2003 on Win XP Home.
Please Help as the database is quite considerably large
and business-critical.
Best Wishes
Andy
.

Reply to this Message

sebastienm - 17 Jul 2004 01:47 GMT

Hi,

You can use the HYPERLINK() function:
HYPERLINK( web_address , text_to_be_displayed )

Say your web addresses are in column A starting in A2
In B2, enter the formula: =HYPERLINK(A2,A2)
Fill down along the data.

Signature

Regards,
Sébastien

Reply to this Message

David McRitchie - 17 Jul 2004 03:26 GMT

A suggestion for your formula,
since you are already showing the URL in cell A2, you can
simply show something like [x] or [link] in your cell with the Hyperlink formula.

=HYPERLINK(A2,"[link]")
or possibly like
=HYPERLINK("http://" & A2, "[x]")
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Hi,
>
[quoted text clipped - 4 lines]
> In B2, enter the formula: =HYPERLINK(A2,A2)
> Fill down along the data.

Reply to this Message