That will work, thanks.

Any idea why I can't get the last 3 characters removed with this condition?

If Right(test, 3) = "/##" Then
MsgBox Left(test, (Len(test) - 3))
End If