ALT ENTER

[Lizzie]

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

 

[Pete_UK]

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