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
|