How to extract the third line from a cell

[Portuga]

Heya,

I have a column of cells that I wish to extract the third line of each.
Each cell has multiple lines separated by a paragraph breaks and the text length of each line is variable.

Example text in A1

Line1- length of text is variable
Line 2- Blank paragraph
Line3 - length of text is variable
Line 4- Blank paragraph
Line 5 (length of text is variable)
Line 6 (length of text is variable)
Line 7 (length of text is variable)

I´m looking for a formula/as that allow me to extract line 3 only. Helper columns is not an issue

Thank you

[dosydos]

is there any kind of uniformailty in each line, such as a "." at the end of the line?

[FDibbins]

Is that ALL in 1 cell?

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Portuga]

There is no uniformity in each line.
That is all in 1 cell.

Lines 2+4 are actual blank paragraphs (as in Alt+Enter)

I guess the result I was looking for in the example would be: "Line3 - length of text is variable"

I´m having trouble attaching a file. Seems the "go advanced" forum option is not working properly for me. (?)

[FDibbins]

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Portuga]

The attachment option is not working but it seems I can insert an image. (?)

Here is the print screen of what I am looking for.

[FDibbins]

testing upload

[FDibbins]

Upload worked OK for me.

Make sure you are using the method I suggested, and NOT using the paper-clip option - that 1 doesnt work

[Portuga]

Ok. I think I got it now. Sorry!!

It´s been a while since I was a regular forumite

[FDibbins]

Try this...
=MID(SUBSTITUTE(A2,CHAR(10),"#",2),SEARCH("#",SUBSTITUTE(A2,CHAR(10),"#",2)),999)

[Portuga]

Try this...
=MID(SUBSTITUTE(A2,CHAR(10),"#",2),SEARCH("#",SUBSTITUTE(A2,CHAR(10),"#",2)),999)

It works in starting to extract from line 3 only, but it´s getting info from 4, 5 and so on.
Maybe it´s related to the length of characters (999)?

But I think that with this as a helper column, it´s possible to extract the result with another formula referencing that as in
=LEFT(D2;FIND(CHAR(10);D2)-1)

P.S - How is your formula inserting the # character at the start?

[Portuga]

There might be a 1 formula solution but yours works well as step 1 and in conjunction with =LEFT(C2;FIND(CHAR(10);C2)-1) will solve my problem.

Thank you!

[FDibbins]

Sorry, missed that you only wanted #3. Try this...
=LEFT(SUBSTITUTE(MID(A2,SEARCH("#",SUBSTITUTE(A2,CHAR(10),"#",1))+2,999),CHAR(10),"#",1),SEARCH("#",SUBSTITUTE(SUBSTITUTE(MID(A2,SEARCH("#",SUBSTITUTE(A2,CHAR(10),"#",1))+2,999),CHAR(10),"#",1),CHAR(10),"#",1))-1)

[Portuga]

Works like a charm! Thank you