Creating a formula with a hyperlink

Is there a way to create a formula to automatically fill in the information
needed for the following hyperlink from an excel worksheet:
http://www.whitepages.com/10001/sear...I2&city_zip=R2

Example: In Cell G2 is someone's first name(John), in Cell I2 is someone's
last name(Smith), and in Cell R2 is their zipcode(75038)=
http://www.whitepages.com/10001/sear...city_zip=75038.
Which I need to do for 1000s of records. Any suggestions?

Look at the hyperlink worksheet function in Excel help

--
Regards,
Tom Ogilvy

"cynthia" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to create a formula to automatically fill in the
information
> needed for the following hyperlink from an excel worksheet:
>
http://www.whitepages.com/10001/sear...I2&city_zip=R2
>
> Example: In Cell G2 is someone's first name(John), in Cell I2 is someone's
> last name(Smith), and in Cell R2 is their zipcode(75038)=
>
http://www.whitepages.com/10001/sear...city_zip=75038.
> Which I need to do for 1000s of records. Any suggestions?
>

I normally use one cell for the hyperlink some thing like in b11

=concatenate("http://www.whitepages.com/10001/sea...=I2&city_zip=";b10)

and then =Hyperlink(b11;"Hyperlink")

works like a charm exept for the little bug that it oppens a new explore every time

good luck