Remove anything after the last slash

[yinkajewole]

what's the vba code to remove any character after the last "" in a string?

 

[Fluff]

Something like

Sub yinkajewole()
   Dim St As String
   St = "C:\Mrexcel\Fluff\Tst"
   MsgBox Left(St, InStrRev(St, "\"))
End Sub

 

[yinkajewole]

Nice one

 

[Fluff]

You're welcome & thanks for the feedback