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
=LEFT(A2,SEARCH(“.”,A2))
As you could see below we have our first sentence in cell B2.
Hope this helped.
