I hope I worded that correctly!

I have a sheet with street addresses. Example:

A B C
123 Elm Street 90210
456 Main Ave 90210

I am trying to create a formula where I can create links to Whitepages.com
to look up phone numbers. The final result I'd like is a link that looks like
this:

http://www.whitepages.com/9900/searc...0210&state_id=

So far I know that I can do this:

=SUBSTITUTE("http://www.whitepages.com/9900/search/ReverseAddress?housenumber=123&street=Elm+St&city_ zip=90210&state_id=",123,A1)

But how do I write a formula that will give me the full result with not only
the House Number, but the Street Name and Zip code?

I guess my main question is how to run the formula for multiple results? Am
I even going about this the right way?

Thanks for any help!!