Let’s see how we could extract the first sentence in a paragraph n excel.
There are scenarios when are faced with unorganized data like texts, twitter data and feedback,extracting first sentence from a long comment or feedback would probably give us a little idea about the sentiments or orientation of what that is all about.
We will see how we could extract first sentence in a string in excel.
We will take the help of full stop in our formula to extract the first sentence as it signifies the delimiter of sentence.
Enter the formula below
As you could see below we have our first sentence in cell B2.
Hope this helped.