The above steps would automatically split the content of the cells based on where the line break occurs in each cell. In my example, I want the result in B2, so I changed the value to $B$2.
Also, you will see the expected result in the ‘Data preview’ section (as shown below). You will not see anything in the box except a tiny blinking dot (if you look hard). Now Use the keyboard shortcut Control + J (hold the ‘Control’ key and then press the ‘J’ key).
You can read more about it here.Īlso read: Go To New Line In Same Cell in Excel Using Text to Column to Split Multiple Lines in a Cellīelow are the steps that will split multiple lines in a single cell into separate cells: Note: If you’re wondering how I managed to insert each address element into a new line in the same cell, you can do that by using the keyboard shortcut – ALT + Enter (it enters a line break).