Re. Internet links

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
..

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.
--
Regards,
Sébastien

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

"sebastienm" wrote in message ...
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.
--
Regards,
Sébastien