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.
