Extract line items in a cell upto the specific number

Hello Friends

I need to extract and separate the cell line items (Separated by Alt+Enter) by formula in light yellow cells.

thanks in advance

Sekar

tRY

d3=TRIM(MID(SUBSTITUTE($B$3,CHAR(10),REPT(" ",LEN($B$3))),(ROWS($D$3:D3)-1)*LEN($B$3)+1,LEN($B$3)))

Copy down

Hello Ankur

Thanks for your formula

Working well.

Thanks again

Sekar

Try this
Enter formula in D3 and copy down

Formula:

Please Login or Register  to view this content.