Forum Discussion
Address
I was given an excel worksheet that has addresses split in the same cell using the return key. I need to get each address in one line. Can I do this?
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.
