Using contents of one cell to extract information from a different cell

[jessebhunt]

Hi Everyone:

I've got a spreadsheet that has partial mailing addresses in Column A. Column B contains a whole bunch of information not related to the mailing address, but also contains the mailing address. I'm hoping that there's a way to search Column B for the info in Column A to find the complete mailing address, and then eliminate all of the information in Column B that's unrelated to the complete mailing address.

As an example...

Column A contains the following:
1234 Some Street, City, ST

Column B contains the following:
A whole bunch of unrelated text. More unrelated text. 1234 Some Street, City, ST 12345. More unrelated text.

Note how column B contains a zip code and Column A does not.

I'm hoping to be able to search Column B for the Contents of Column A in order to get the full address, including the zip code, and eliminate all of the unrelated text.

I think this might be a long shot, but I'm hoping there's a way that I don't know about.

Thanks in advance for any assistance that you can provide!