Re: [libreoffice-users] How to do this in Calc

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 <70147persson@telia.com> 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: users+unsubscribe@global.libreoffice.org
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