extract the first sentence from a paragraph using Kutools
Greetings,
I am using Kutools of excel to extract the first sentence from a long paragraph. My wish is to extract the first sentence ended by colon ":" from a paragraph containing more than one colon. When I put “*:” in “extract text” dialog box, I get almost the whole paragraph up to the last colon extracted.
I explain myself. My paragraph contains many sentences eg. sentence1: sentence 2: sentence 3: sentence 4.
I want to extract only sentence1. Currently Kutools extract sentence1: sentence 2: sentence 3: My humbly request for assistance is to extract only sentence1:
Thank you for your support.
|