RIGHT and LEN does not work

[garfiola]

I try to remove the last 5 characters in each row

I used this formula

=RIGHT(L65,LEN(L65)-5)

in L65 i have this data 231S_COR_1250

I want it to look like this

231S_COR

I used that formula and I get error (the formula you typed contains the error and it marks this inside the formula L65,LEN

 

[scottylad2]

you got it back to front, use this instead =LEFT(L65,LEN(L65)-5)

 

[Michael M]

Try

=LEFT(L65,LEN(L65)-5)

 

[Peg F]

Garfiola,

Please try <TABLE style="WIDTH: 115pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=153><COLGROUP><COL style="WIDTH: 115pt; mso-width-source: userset; mso-width-alt: 5595" width=153><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 115pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" id=td_post_2885888 height=20 width=153>=LEFT(L65,LEN(L65)-5)</TD></TR></TBODY></TABLE>

Hope that helps.

Peg

 

[xenou]

Yes, the formula was backwards (left instead of right). Although it doesn't explain why it wouldn't take.

I would be sure to disable or uninstall all addins that you are using - this is often a culprit in these cases. And though it's a worn-out strategy, give your pc a reboot too as you never know!

 

[garfiola]

It does not work

=LEFT(L7,LEN(L7)-5)

I pasted this is M7

I get error, and I know the formula is right

What is wrong with my excel? I have excel 2010


If I click on functions button ---- under text i get this L7,LEN(L7)-5 and it say invalid

Here is the link to my excel file

http://www.mediafire.com/?tb3f3nu4whqj7tz

After I pressed enter i got this in the formula field =LEFT("L7,LEN(L7)-8")

and only one letter in the M7 field

 

[Michael M]

Did you follow the instructions provided by Xenou ?
That should fix any other problems.
You could also posta sample of your data to see if we can pick up some other error
See the 2nd line of my tag for the Mr Excel HTML download

 

[Rick Rothstein]

Here is the link to my excel file

http://www.mediafire.com/?tb3f3nu4whqj7tz

After I pressed enter i got this in the formula field =LEFT("L7,LEN(L7)-8")

and only one letter in the M7 field

When I load your file into XL2007 (I don't have XL2010), this is the formula I see in M7...

=LEFT(1:7(L7)-8)

which, of course, is not a valid formula.

 

[Michael M]

Just managed to look at the sample
This won't work

=LEFT(1:7(L7)-8)

You will have to put the formula

=LEFT(L2,LEN(L2)-5)

in say M2 and copy down.

 

[garfiola]

I am sorry, something went wrong with my excel

I tried again, I put =LEFT(L7,LEN(L7)-5) in M7

agan the error

I cant save the file because formula has error