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

Attached Files

example.xlsx (8.2 KB, 11 views)