eroro in simple function
 

I am getting this standard error message with this function.. really strange:

=LEFT(A2, LEN(A2)-2)

eroro in simple function
 

I am assuming you are talking about a function in code, not in a spreadsheet?
You can not just reference A2. You have to reference a range, something like
this...

=LEFT(range("A2"), LEN(range("A2")-2)
--
HTH...

Jim Thomlinson


"Calle" wrote:

I am getting this standard error message with this function.. really strange:

=LEFT(A2, LEN(A2)-2)

eroro in simple function
 

I tried that and also:

=left(a1,len(a1)-1)

wont work

eroro in simple function
 

It's code in a cell, btw, not a VBA macro or anything

"Calle" wrote:

I tried that and also:

=left(a1,len(a1)-1)

wont work

eroro in simple function
 

Should this work:
=LEFT(range("'Schakt dörr'!G14"), LEN(range("'Schakt dörr'!G14")-3)

strange that it's not working...

eroro in simple function
 

Is there something in A2? If not you will get the #VALUE error.

Jeff

"Calle" wrote in message
...
I am getting this standard error message with this function.. really
strange:

=LEFT(A2, LEN(A2)-2)