See below...
On Sat, Feb 7, 2015 at 4:59 PM, Kaj <70147pers...@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+unsubscr...@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
