Remove VBTAB from the end of string

[Pistol34]

I have this string 1=10 2=20 I want to remove the VBTAB from the end. Trim won't remove it and I tried to left(string, len(string) - VBTAB), but like I thought Type Mismatch. Is there a function that I can use?

Thanks

 

[MisterC]

You're close...
try

left(string, len(string) - 1)

 

[JohnYingling]

Safer is:
If Right(string,1) = VbTab then string = Left(string,len(string)-1)

http://WWW.VBCompare.Com