#1
|
|||
|
|||
extracting the first sentence from a paragraph using FIND function
Greetings,
Last week I got help from this forum about extracting a first sentence from a paragraph and I really appreciated the help. However, I still found some problems. Most sentences are ended by a colon and this enables me to find them using FIND() function. The problem arises where the sentence is ended by "enter" i.e the sentence is a title whereby after the first sentence they go back to start a new sentence by typing "enter". I attach an example. The support needed is to find the sentence ended by "enter" so that I can extract it as i did on other first sentences ended by colon. Thank you for your help |
#2
|
||||
|
||||
Like this ?
=LEFT(A2,FIND(CHAR(10),A2)-1)
__________________
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
|
|||
|
|||
The function works, thank you Pecoflyer. I previously used it at a wrong sheet, sorry. I learned char() function, thank you.
Last edited by Tesla; 03-25-2019 at 07:55 AM. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
extract the first sentence from a paragraph using Kutools | Tesla | Excel | 7 | 03-22-2019 06:04 AM |
Extracting Skills in Paragraph Format | mycon73 | Excel | 2 | 07-26-2018 10:39 PM |
Keeping the source format when extracting data from multiple cells using Vlookup function | praboos2001 | Excel | 6 | 11-15-2016 04:40 AM |
Find Word then Highlight Whole Sentence and Paragraph Around it | ChrisOK | Word VBA | 4 | 09-08-2016 10:16 PM |
How do I get a summary sentence for each paragraph shown in outline view | the_aj | Word | 1 | 08-05-2011 12:27 PM |