How to filter or extract cells with address and postal codes

[tony2025]

Hello,
How do I filter or extract cells with address and postal codes only.

In a large excel sheet, there are cells with address and postal codes. (All in one cell througout the sheet)

Is there a way to say: look in the cell and if it has a postal code in it, copy the entire cell (Including whats before the postal code "Address")?

I would like to extract or filter so I can copy paste it into a new sheet.

Thank you in advance for your help.

 

[alansidman]

How about some examples of what your data looks like. Several different and unique examples will help to answer.

 

[tony2025]

How about some examples of what your data looks like. Several different and unique examples will help to answer.

Hi Alan,
Here is the example. I guess I cannot post the excel sheet so here is the image in dropbox.

https://www.dropbox.com/s/zd0p1iq886wiik8/mrexcelq.PNG?dl=0