Filter Zip Codes from a list codes

I have two questions:

First, I have a list of zip codes in this exact format- 40003,40006,40007,40010,40011,40012,40014,40018,40019. When I paste them in Excel, they end up all in one cell. How do I get them in individual cells?

Second, I have a list of addresses (zip in separate column). I want to able to take the list above and filter my address list to keep only those addresses that include one of the zip codes from my list above. There's 400 addresses with zip codes and 840 zip codes in the list so I need to automate the process.

Here's an attachment showing what I want.

I have a list of addresses. I also have a list of zip codes that represent all zip codes within a 150 mile radius of Cincinnati. I want to have a column that says True or False if the address zip code is included in the list of zip codes within the radius. Pretty simple I would imagine for the Excel guru.

Hi jaugent27

Please insert the following formula in your "Example" column:
=IF(ISERROR(VLOOKUP(VALUE(D4),$F$4:$F$432,1,FALSE)),FALSE,TRUE)