如果您展开所有换行符char演员将空格的原始字符串的长度，然后拿起第一，第二，最后，下一个到最后成为简单的数学。

If you expand all of the line feed characters to spaces the length of the original string then picking up the first, second, last, next-to-last becomes simple maths.

'first
=TRIM(LEFT(SUBSTITUTE(A2, CHAR(10), REPT(CHAR(32), LEN(A2))), LEN(A2)))
'second
=TRIM(MID(SUBSTITUTE(A2, CHAR(10), REPT(CHAR(32), LEN(A2))), LEN(A2)*1, LEN(A2)))
'last
=TRIM(RIGHT(SUBSTITUTE(A2, CHAR(10), REPT(CHAR(32), LEN(A2))), LEN(A2)))
'next-to-last
=TRIM(MID(SUBSTITUTE(A2, CHAR(10), REPT(CHAR(32), LEN(A2))), LEN(A2)*(LEN(A2)-LEN(SUBSTITUTE(A2, CHAR(10), ""))-1), LEN(A2)))
'second-from-last
=TRIM(MID(SUBSTITUTE(A2, CHAR(10), REPT(CHAR(32), LEN(A2))), LEN(A2)*(LEN(A2)-LEN(SUBSTITUTE(A2, CHAR(10), ""))-2), LEN(A2)))

'all in sequence when filled down (E3 per supplied image)
=TRIM(MID(SUBSTITUTE(A$2, CHAR(10), REPT(CHAR(32), LEN(A$2))), LEN(A$2)*(ROW(1:1)-1)+1, LEN(A$2)))