pasting content of cell into URL

[slushnee]

I have a long Excel spreadsheet where I would like to automatically
paste the contents of a cell into a given URL, so I can automatically
search for information on the web that is related to the contents of
the cell in my spreadsheet.
How can I do that in Excel ?

thanks for any help,

cheers
Stefan

 

[Guest]

Hi Stefan:

If A1 contains a topic, like dog. Then in another cell enter:

=HYPERLINK("http://www.google.com/search?hl=en&q=" & A1 & "&btnG=Google +
Search","find it")

Clicking on this cell will run the Google search engine on the contents of
A1. You can modify this formula to use the search engine of your choice.

 

[slushnee]

thanks a lot !
it works!

 

[Guest]

You are very welcome! Have fun with it.