=left or =right
Yeah, I don't think I can even give myself a satisfactory explanation
for that little brain snap.
Apologies to all. I'm off to bed.
Regards
Martin
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Are you sure, Martin? Colons are normally used to define an array, so a
colon in this case would be invalid syntax. The list separator, a
semi-colon in some regional settings, is more likely to be a comma in
other settings. Hence you may want =LEFT(A1,LEN(A1)-1)*1, or
alternatively =--LEFT(A1,LEN(A1)-1)
--
David Biddulph
"MartinW" wrote in message
...
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.
"Hansueli" wrote in message
...
=LEFT(A1;LENGTH(A1)-1)*1
Rgds. Hansueli
|