|
|
#1
03-21-2019, 06:41 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Kutools | Ahmedfares | Excel | 3 | 03-20-2019 10:17 AM |
 Extract a string from a paragraph
|
kirkm | Word VBA | 7 | 09-11-2016 06:13 PM |
| Find Word then Highlight Whole Sentence and Paragraph Around it | ChrisOK | Word VBA | 4 | 09-08-2016 10:16 PM |
|
Word thinks 1 sentence is 2 paragraphs and won't let me delete the extra paragraph symbol
|
jrasicmark | Word | 1 | 12-05-2014 01:50 AM |
|
How do I get a summary sentence for each paragraph shown in outline view
|
the_aj | Word | 1 | 08-05-2011 12:27 PM |
Windows 7 32bit 
Office 2003
Threaded Mode