Sep 07 2022 01:37 PM
If you want the addresses in one cell on one line:
Select the column with the addresses.
Press Ctrl+H to activate the Replace dialog.
Click in the 'Find what' box and press Ctrl+J (this is the line break character).
Click in the 'Replace with' box and enter a space.
Click 'Replace All'.
If you want the address split into several cells on the same row:
Make sure that there are enough empty columns to the right of the column with the addresses.
Select the column with the addresses.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Select Other, then click in the box next to it and press Ctrl+J (this is the line break character).
Click Finish.
Sep 19 2022 09:28 AM