Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2019, 12:03 AM
Tesla Tesla is offline extracting the first sentence from a paragraph using FIND function Windows 7 32bit extracting the first sentence from a paragraph using FIND function Office 2003
Advanced Beginner
extracting the first sentence from a paragraph using FIND function
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default 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
Attached Files
File Type: xlsx example.xlsx (8.2 KB, 9 views)
Reply With Quote
  #2  
Old 03-25-2019, 01:10 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline extracting the first sentence from a paragraph using FIND function Windows 7 64bit extracting the first sentence from a paragraph using FIND function Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 03-25-2019, 04:56 AM
Tesla Tesla is offline extracting the first sentence from a paragraph using FIND function Windows 7 32bit extracting the first sentence from a paragraph using FIND function Office 2003
Advanced Beginner
extracting the first sentence from a paragraph using FIND function
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
extracting the first sentence from a paragraph using FIND function extract the first sentence from a paragraph using Kutools Tesla Excel 7 03-22-2019 06:04 AM
extracting the first sentence from a paragraph using FIND function Extracting Skills in Paragraph Format mycon73 Excel 2 07-26-2018 10:39 PM
extracting the first sentence from a paragraph using FIND function 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
extracting the first sentence from a paragraph using FIND function How do I get a summary sentence for each paragraph shown in outline view the_aj Word 1 08-05-2011 12:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft