Thread: extract or delete part of rows
View Single Post
 
Old 08-23-2021, 02:24 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
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.
Reply With Quote