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