Thread
:
extract or delete part of rows
View Single Post
08-23-2021, 03:05 AM
Pecoflyer
Windows 7 64bit
Office 2010
Expert
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Another approach
Code:
=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99),2),100))
Pecoflyer
View Public Profile
Find all posts by Pecoflyer