Pam
LTRIM and RTRIM are functions used in VBA, not a worksheet function. They(or
TRIM) are not the Function you want.
See other answers to your post.
Gord Dibben Excel MVP
On Tue, 30 Nov 2004 14:11:03 -0800, Pam wrote:
3 characters off the right side of a string and post the new results in a new
cell. In other words, in cell A1 I have 123abc456. In B1, I tried to put
rtrim(A1,3) so I could produce 123abc.
I remember doing this in earlier versions of Excel. How can I do it in 2002?
|