Thanks very much for the reply, but that is not the result I was looking for (however, I do like the vbCr usage. I will have to look into that one a little deeper).


I am trying to end up with a line of code that would look something like this:
T2 = Left(T1, Len(T1) - 2)


Keeping all the Dim and Set statements I have. Its kinda an odd way to do it, but I'm just experimenting. Thanks for your help.