To separate parts of an address or dat

Separate the Two Lines into Two Separate Columns

Make sure there is an empty column to the right of the address ...

Select the column with the addresses in it ...

Select the text to columns function from the data menu.

When the text to columns wizard opens, select Delimited and click Next.