Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
pasting content of cell into URL
thanks a lot !
it works! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Macro on cell content | New Users to Excel | |||
Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) |