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

Hi :)
Glad it worked.  !Shocking to see Brian was the one with the probably
best correct answer.  Ok, quite the opposite of shocking really.  Nice
one!

Congrats and regards from
Tom :)



On 10 February 2015 at 00:07, "J. Van Brimmer" <jerry.vb@gmail.com> wrote:
> Sorry for the late reply, life got in the way.
>
> >  On Sat, Feb 7, 2015 at 4:43 PM, Brian Barker wrote:
> >
> > Try:
> >
> > =MID(A1;12;5)&" - "&MID(A1;34;5)
> > > >
>
> This works, after I realized that I had to change A1 to the appropriate
> reference number.
>
>
>
>
> Thanks! To all that replied, it all helped.
>
>
>
> Cheers,
>
> --
> 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

-- 
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