Extract First Sentence In Excel

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.

Capture

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))

Capture

As you could see below we have our first sentence in cell B2.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply