| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
eroro in simple function
I am getting this standard error message with this function.. really strange:
=LEFT(A2, LEN(A2)-2) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
eroro in simple function
I tried that and also:
=left(a1,len(a1)-1) wont work |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Any Help with a Simple Function? | Excel Programming | |||
| COM Add-in - Simple Function | Excel Programming | |||
| simple if then function | Excel Worksheet Functions | |||
| A simple function | Excel Programming | |||
Hybrid Mode
