Re: [libreoffice-users] Help with Conditional Macro Please

On 26/10/14 18:31, Brian Barker wrote:
> At 18:14 26/10/2014 +0000, Alastair Noname wrote:
> > OK, looks simpler and though I would give it a try but having loaded
> > my .csv file none of the formula are working. Is there somewhere these
> > can be turned on and off?
>
> Do you mean that you see formulae instead of the results of those
> formulae? If so, remove the tick from Tools | Options... | LibreOffice
> Calc | View | Display | Formulae.
>
> Note also that if you save your work in its current .csv format, any
> formulae cannot be saved. Instead, just the current values of results of
> any formulae will be saved, and the functionality will be lost once you
> reopen the document. To avoid this, you need to save the document in a
> spreadsheet format, sensibly LibreOffice's default .ods format.
>
> I trust this helps.
>
> Brian Barker
Hi Brian, many thanks.  I worked that out and started over.  I have 
achieved much of what I want with the "easier" bits using CONCATENATE 
but how do I insert spaces or commas?  The resulting text looks dreadful 
all joined up
I have =CONCATENATE(C2,D2,TEXT(

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