View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cynthia Cynthia is offline
external usenet poster
 
Posts: 86
Default 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?