extract or delete part of rows

yacov · #1 08-23-2021, 01:55 AM

Hi.
I have a column with a lot of lines, each line contains a sentence with a different number of words. I would like in each line to leave only the first two words. Is it possible?
Thanks.

ArviLaanemets · #2 08-23-2021, 02:24 AM

With your sentences in column A, starting from A2, into any other column enter the formula like

Code:

=IFERROR(LEFT($A2,FIND(" ",$A2,FIND(" ",A$2,1)+1)-1),$A2)

, and copy down.

yacov · #3 08-23-2021, 02:39 AM

thanks a lot. works great.

Pecoflyer · #4 08-23-2021, 03:05 AM

Another approach

Code:

=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99),2),100))

Purfleet · #5 08-23-2021, 05:07 AM

Not sure with out an example but flash fill should work

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete blank table rows in merged document and split document in docx and pdf based on excel rows	Alex1s85	Word VBA	5	05-22-2021 12:05 PM
Macro to extract CCIs as separate entries when part of a text string	Cray_Z	Word VBA	5	01-13-2021 03:45 PM
Delete blank rows between the two rows that contain data	beginner	Excel Programming	5	12-26-2014 12:29 AM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Is there a way to delete the beginning part of an array so it doesn't overflow?	omahadivision	Excel Programming	4	01-15-2014 11:22 PM