ALT ENTER

L

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
 
P

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
 
Top