I can't seem to use RTRIM or LTRIM in Excel 2002. I want to trim.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pam - 30 Nov 2004 22:11 GMT

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?

Reply to this Message

bigwheel - 30 Nov 2004 23:00 GMT

> 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?

TRIM removes all spaces from text except for single spaces between words.
LEFT(A1,6) will achieve your desired result.

Reply to this Message

Bernie Deitrick - 30 Nov 2004 23:54 GMT

Pam,

If your string length can vary then a more general solution is

=LEFT(A1,LEN(A1)-3)

HTH,
Bernie
MS Excel MVP

>3 characters off the right side of a string and post the new results in a
>new
[quoted text clipped - 3 lines]
> I remember doing this in earlier versions of Excel. How can I do it in
> 2002?

Reply to this Message

Gord Dibben - 02 Dec 2004 00:08 GMT

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

>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?

Reply to this Message