#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Is there no support on the Kutools site?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Give examples of your text strings, please.
If your sentences always have a structure like: sentence1: sentence 2: sentence 3: sentence 4 you can use =MID(A1,1,FIND(":",A1)) |
#4
|
|||
|
|||
kindly find attached an example. As you requested, my paragraphs are not uniform. some of them are like this
sentence1: sentence2:sentence3 others are like this sentence1: sentence2 |
#5
|
|||
|
|||
What about this?
|
#6
|
|||
|
|||
Thank you very much, i took time to understand the formula. Now i understand thank you, i am zero in excel
Last edited by Tesla; 03-22-2019 at 05:43 AM. |
#7
|
|||
|
|||
Thank you very much, i took time to understand the formula. Now i understand thank you, i am zero in excel[/quote]
|
#8
|
|||
|
|||
You're welcome.
|
Thread Tools | |
Display Modes | |
|
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 |