Hyperlink to specific web site info

[Doug Day]

I have spreadsheet which is a column of movie names. is it possible to
hyperlink to the Internet Movie Data Base info for the move?

I tried adding http://www.imdb.com/find?s=tt&q=move name which is what
the site itself does when a title is specified. I'd like to do it in a
generic way in the spreadsheet so I don't have to modify each cell's
hyperlink.

I need a way to reference the cell's contents in the Edit Hyperlink
Dialog. I tried, for example, variations on the Cell function like
http://www.imdb.com/find?s=tt&q=cell("contents",a1) or
http://www.imdb.com/find?s=tt&q="cell("contents",a1)", etc.

 

[Edwin Tam]

You may try the "hyperlink" worksheet function.

For example, you want to go to:
http://www.microsoft.com/mac

In cell A1, you type:
=HYPERLINK("http://www.microsoft.com/" & A3)
Then, in cell A3, you type:
mac

You'll then in cell A1 got a hyperlink to the URL:
http://www.microsoft.com/mac

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[Bill]

This is an easy one - just drag the URL from the browser location bar
to the cell that contains the text to which you want to apply the link.
That text will then be hperlinked!

Bill

 

[Bill]

This is an easy one - just drag the URL from the browser location bar
to the cell that contains the text to which you want to apply the link.
That text will then be hperlinked!

Bill