I have a complete worksheet that has two lines in each cell. I have to
seperate the two lines into two cells.

Is there a quick way of doing this task?

Thank you.

Lizzie

Presumably, as the title for the thread is Alt Enter, those two lines
are split using Alt-Enter?

If so, and assuming your data is in A1, put this in B1:

=LEFT(A1,FIND(CHAR(10),A1)-1)

and this in C1:

=RIGHT(A1,LEN(A1)-FIND(CHAR(10),A1))

and then copy these two formulae down as far as you need.

Hope this helps.

Pete

On Jan 14, 4:47*pm, Lizzie wrote:
I have a complete worksheet that has two lines in each cell. *I have to
seperate the two lines into two cells.

Is there a quick way of doing this task?

Thank you.

Lizzie