G
Guest
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/sea...egins_with=1&firstname=G2&name=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/sea...th=1&firstname=John&name=Smith&city_zip=75038.
Which I need to do for 1000s of records. Any suggestions?
needed for the following hyperlink from an excel worksheet:
http://www.whitepages.com/10001/sea...egins_with=1&firstname=G2&name=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/sea...th=1&firstname=John&name=Smith&city_zip=75038.
Which I need to do for 1000s of records. Any suggestions?