What you need is a large Whiskey
No need for macros

=HYPERLINK("http://"&A1&".com","www."&A1&".com")

in A2, I would probably use just

=HYPERLINK("http://"&A1&".com",A1)

if I were you



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


wrote in message
oups.com...
Hello,

I am trying to create a function that will allow a different hyperlink
to appear depending upon what piece of data is entered into a specefied
cell.

...for instance if I were to type "google" into cell A1 I would then
have a hyperlink to www.google.com created in cell A2.

I have hundereds of different possible hyperlinks and I think that the
ideal way to do this is using a macro but I am not quite sure.

Thanks for any assistance.