Maybe you could use an adjacent cell and a formula like:
=hyperlink("http://www.search.com/search=" & a1, "Click me!")
(if Dog was in A1)
simonrowland wrote:
Hi,
I work for a charity - we're going through our donors at the moment and have
to search for each one individually in the charity commision website.
I was wondering if there's a way of using excel, which already has our data
in, to generate urls linking to the above site's (or any) search engine
incorporating the contents of a cell.
ie:
i'm searching for dog
the search page url is www.search.com/search=??
and want to genenerate www.search.com/search=dog
I want to generate one of each of these for each donor
any thoughts would be greatly appreciated
thanks
simon
--
Dave Peterson