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

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