I want to truncate the portion of a string that follows my third "\".
So data looks like, C:\TEMP\RESULTS\FINANCE\3q\Findings and I want just
C:\TEMP\RESULTS\FINANCE\

Your example does not match your request, but anyway:

s = "C:\TEMP\RESULTS\FINANCE\3q\Findings"
t = "\"
U = Split(s, t)
s = U(0) & t & U(1) & t & U(2) & t
--
Gary's Student


"bwmaher" wrote:

I want to truncate the portion of a string that follows my third "\".
So data looks like, C:\TEMP\RESULTS\FINANCE\3q\Findings and I want just
C:\TEMP\RESULTS\FINANCE\

here's a formula that should work if the string is in A1

=LEFT(A1,FIND(CHAR(7),SUBSTITUTE(A1,"\",CHAR(7),3) ))
--


Gary


"bwmaher" wrote in message
...
I want to truncate the portion of a string that follows my third "\".
So data looks like, C:\TEMP\RESULTS\FINANCE\3q\Findings and I want just
C:\TEMP\RESULTS\FINANCE\

Thank you, Gary. it worked perfectly.

"Gary Keramidas" wrote:

here's a formula that should work if the string is in A1

=LEFT(A1,FIND(CHAR(7),SUBSTITUTE(A1,"\",CHAR(7),3) ))
--


Gary


"bwmaher" wrote in message
...
I want to truncate the portion of a string that follows my third "\".
So data looks like, C:\TEMP\RESULTS\FINANCE\3q\Findings and I want just
C:\TEMP\RESULTS\FINANCE\