=left or =right
And another adjustment.
Those semi colons ;
Should be colons :
"MartinW" wrote in message
...
Slight adjustment there,
=LEFT(A1;LENGTH(A1)-1)*1
Should be
=LEFT(A1;LEN(A1)-1)*1
And just to expand a little
=LEFT(A1;LEN(A1)-1)
will return the number as text.
HTH
Martin
"Hansueli" wrote in message
...
=LEFT(A1;LENGTH(A1)-1)*1
Rgds. Hansueli
|