VB Code:
  1. if right(mystring,1) = "C" then

  2.        mystring = left( mystring,Len(mystring)-1)

  3. end if

You forgot the -1