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

[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

 

[Thomas Hardy]

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

 

[Alan]

Thomas,

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

Alan

 

[Bob Umlas]

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

 

[Gord Dibben]

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

 

[Gord Dibben]

Thanks

Found it kinda handy.............fewer steps.


Gord