Splitting up multiple lines in one cell to one line per cell inmultiple cells

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have cells each of which contains multiple lines of text (use Alt-
Enter at end of each line when entered).

Is there an easy way to copy these lines in a single cell and past
them into multiple cells, with one line per cell?

Thanks, Alan
 
Alan,

I usually copy the contents of the cell, paste in Notepad, recopy and then
paste in Excel.

Shame there is nothing on paste special for this.

Thomas
 
Thomas,

Thanks. Notepad on Windows 2003 did not help, but what you
described worked when I used WordPad.

Alan
 
You can do it all in Excel...
Select the cell with the multiple lines, use Data/Text-to-columns, click in
the "Other" checkbox in step 2, hold the Alt key down, press 010, let go of
the alt key, click OK. Now select the separated cells/paste special
transpose..., then clear the cells to the right.
Bob Umlas
Excel MVP
 
One other method if you want the lines split down a column. Say A1 with 4
lines into A1:A4

Select A1 and copy the contents from Formula bar.

De-select A1, re-select A1:A4.

CTRL + v


Gord Dibben MS Excel MVP
 
Back
Top