Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I can't seem to use RTRIM or LTRIM in Excel 2002. I want to trim.
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? |
#2
|
|||
|
|||
"Pam" wrote in message
... 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. |
#3
|
|||
|
|||
Pam,
If your string length can vary then a more general solution is =LEFT(A1,LEN(A1)-3) HTH, Bernie MS Excel MVP "Pam" wrote in message ... 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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |