View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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