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.