Split lines of text into columns in Excel

If you’ve ever had a list of values that contain line breaks, you might’ve wondered how to split each line into its own column quickly.

Say you’ve got a list of addresses in A2:A11, each one containing four lines within the same cell.

To separate them into columns:

1. Select your data.
2. On the Data tab, click Text to Columns (or press Alt, A, E).
3. Choose Delimited, then click Next.
4. Tick Other and make sure the other options are unticked.
5. In the text field beside Other, press Ctrl + J (this represents a line break).
6. Click Finish.

Each line now sits neatly in its own column!

Watch the video