#1
|
|||
|
|||
extract or delete part of rows
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. |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
thanks a lot. works great.
|
#4
|
||||
|
||||
Another approach
Code:
=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99),2),100)) |
#5
|
|||
|
|||
Not sure with out an example but flash fill should work
|
Thread Tools | |
Display Modes | |
|
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 |