On 11/10/2013 06:32 PM, Brian Barker wrote:
At 21:17 10/11/2013 -0500, Jay Lozier wrote:
Why not set a cell to the formula =right(len(CELL)-1) which returns
the all the characters except for the first.
That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote
mark because it's *not there*! The simpler formula =RIGHT(Xn;LEN(Xn))
would work, but that's just a complicated way of saying =VALUE(Xn).
Brian Barker
Why is everyone straying away from the fact that there is a simple
extension developed by Cor (one of our brilliant devs) which
accomplishes all of this? Just curious if there's a benefit to doing
these formula techniques instead of just pushing a button on a nice gui
All the best,
Joel
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
