Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default pasting content of cell into URL

thanks a lot !
it works!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default pasting content of cell into URL

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


"slushnee" wrote:

thanks a lot !
it works!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using macro to copy a part of a cell content to next cell Charles Excel Discussion (Misc queries) 6 May 31st 06 05:57 AM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Macro on cell content Riko Wichmann New Users to Excel 2 March 3rd 05 02:07 PM
Numeric content in one cell ( implicit formula ) and the result in another one PeDevillers Excel Discussion (Misc queries) 7 March 2nd 05 07:40 AM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"