I previously posted this example showing how to enter separate lines of text into a single cell. This example shows how to move each line of a cell’s text into its own cell.
The first picture shows five cells in range A3:A7 that each have three lines of text for a person’s name, street address, and their city, state, and zip code.
Step 1: Parse each cell’s lines of text. Select the range, and press the
Alt+A+E keys to show the Text to Columns Step 1 Wizard.
Step 2: In the Text to Columns Step 1 Wizard, choose the Delimited option and click the Next button.
Step 3: In the Text to Columns Step 2 Wizard, select Otheras the delimiter, and in the Other field press the
Ctrl+J keys. This will create an invisible character that delimits the cells’ individual lines of text. You do not need to go to Step 3; just click the Finish button.
The final result.