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.
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.