Which language are you using in Calc? The commands are language
dependant. Those I wrote is for an English version.
/Kaj
Den 2015-02-08 02:31, skrev "J. Van Brimmer":
See below...
On Sat, Feb 7, 2015 at 4:59 PM, Kaj <[email protected]> wrote:
If this is a simple string, then the extract is quite simple. But if it
contains date formulas in a way, it is a wee more complicated. But let us
start with the simple assumption, that the string is exactly the one you
give, including e.g. the lacking space before "to":
Assuming your string is in cell A1, cell B1 could contain:
=CONCATENATE(MID(A1,12,5)," - ",MID(A1,34,5))
When I tried that I get in column B:
e lnf -
A wee more safe could be:
=CONCATENATE(MID(A1,12,5)," - ",LEFT(RIGHT(A1,8),5))
When I tried that I got in column B:
e lnf - ormat
--
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
