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

 

[garfiola]

I disabled all addins

tried again the formula

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


I get an error in formula again, I really dont understand

In the formula field I can see #REF! now. What to do?

 

[garfiola]

FOUND AN ERROR

I HAVE TO USE THIS

=LEFT(L7;LEN(L7)-5) instaed of =LEFT(L7,LEN(L7)-5)

SO weird

 

[Aladin Akyurek]

FOUND AN ERROR

I HAVE TO USE THIS

=LEFT(L7;LEN(L7)-5) instaed of =LEFT(L7,LEN(L7)-5)

SO weird

You probably have a non-American system, which uses semi-colon as list separator, not comma.