pasting content of cell into URL
 

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

pasting content of cell into URL
 

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.
--
Gary's Student


"slushnee" wrote:

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

pasting content of cell into URL
 

thanks a lot !
it works!

pasting content of cell into URL
 

You are very welcome! Have fun with it.
--
Gary's Student


"slushnee" wrote:

thanks a lot !
it works!