can i use excel to generate web links
 

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

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