extracting the first sentence from a paragraph using FIND function

		Microsoft Office Forums > Microsoft Excel > Excel
extracting the first sentence from a paragraph using FIND function

FAQ

Thread Tools

Display Modes

03-25-2019, 01:10 AM

Pecoflyer

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,948

Pecoflyer has a reputation beyond repute

Like this ?

=LEFT(A2,FIND(CHAR(10),A2)-1)

__________________
Using O365 v2503 - 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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 AM.