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)