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" wrote in message
...
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 :)


--
nijunge
------------------------------------------------------------------------
nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404
View this thread: http://www.excelforum.com/showthread...hreadid=396257