View Single Post
 
Old 03-25-2019, 12:03 AM
Tesla Tesla is offline Windows 7 32bit Office 2003
Advanced Beginner
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default extracting the first sentence from a paragraph using FIND function

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
File Type: xlsx example.xlsx (8.2 KB, 11 views)
Reply With Quote