pasting content of cell into URL

S

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
 
G

Gary''s Student

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