Address

New Contributor

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?

2 Replies

@Jacque2090 

 

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.

@Hans Vogelaar 

 

Thank you so much for the instructions you sent!  It worked and was a huge help.