extracting the first sentence from a paragraph using FIND function

[Tesla]

Greetings,


Last week I got help from this forum about extracting a first sentence from a paragraph and I really appreciated the help. However, I still found some problems. Most sentences are ended by a colon and this enables me to find them using FIND() function. The problem arises where the sentence is ended by "enter" i.e the sentence is a title whereby after the first sentence they go back to start a new sentence by typing "enter".
I attach an example. The support needed is to find the sentence ended by "enter" so that I can extract it as i did on other first sentences ended by colon.

Thank you for your help

[Pecoflyer]

Like this ?


=LEFT(A2,FIND(CHAR(10),A2)-1)

[Tesla]

The function works, thank you Pecoflyer. I previously used it at a wrong sheet, sorry. I learned char() function, thank you.