On Sat, Feb 7, 2015 at 4:59 PM, Kaj <[email protected]> wrote: > > > Assuming your string is in cell A1, cell B1 could contain: > > > =CONCATENATE(MID(A1,12,5)," - ",MID(A1,34,5)) > > A wee more safe could be: > > =CONCATENATE(MID(A1,12,5)," - ",LEFT(RIGHT(A1,8),5)) > > >
In all fairness to Kaj, his formulas also worked! Thanks Kaj! -- 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
