Help me in this

[ddda123]

Let assume this is the paragraph

"This is the first line in the para. This is the second line in the para. This is the third line in the para."

I want to paste in such a way that first line should be pasted in the first cell i.e A1 of the spreadsheet and second line in the second cell of the spreadsheet and so on.

For the given example, I want
A1- This is the first line in the para.
B2-This is the second line in the para.
C2-This is the third line the para.

Thanks

 

[ddda123]

Sorry it is B2 and C2 it is B1 and C1;

 

[ddda123]

Let assume this is the paragraph

"This is the first line in the para. This is the second line in the para. This is the third line in the para."

I want to paste in such a way that first line should be pasted in the first cell i.e A1 of the spreadsheet and second line in the second cell of the spreadsheet and so on.

For the given example, I want
A1- This is the first line in the para.
B2-This is the second line in the para.
C2-This is the third line the para.

Thanks

It is not B2 and C2, it is B1 and C1

 

[FDibbins]

OK do you maybe want to take a few minutes and make up your mind lol?

Maybe post the question here again, using the correct references?

 

[admiral100]

Hi,

Let's say the full paragraph is in D1 and between lines there is .

A1 =TRIM(MID(SUBSTITUTE($D$1,".",REPT(" ",1000)),ROW(D1)*1000-999,1000))

and drag down

 

[ddda123]

Hi,

Let's say the full paragraph is in D1 and between lines there is .

A1 =TRIM(MID(SUBSTITUTE($D$1,".",REPT(" ",1000)),ROW(D1)*1000-999,1000))

and drag down

Thanks Working