Deleting second line in a cell

Hello

I have a dataset where the address and ZIP columns contain 2 lines of data, please see the attached file.

However, the first line of the address and zip is correct and the second line isn't

How can I keep only the first line of the cell and delete the second one? There are about 49K records in the final file


Many thanks