Hi :) I think you can add extra characters in speech-marks can't you? Something like;
=CONCATENATE(C2," ",D2," ",TEXT(E2,"dd/mm/yy")," ",TEXT(F2,"dd/mm/yy)) Regards from Tom :) On 26 October 2014 19:44, Budgie <[email protected]> wrote: > 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, > Sorry about last post. Email client (Thunderbird on X64 openSUSE 13.1, > with KDE desktop) has just stalled. > > I have been working on the easy bits of my problem and have a solution > except that the answer looks dreadful as I cannot find out how to insert > spaces or commas into results of the formula to get the format > presentable. I am using:- > > =CONCATENATE(C2,D2,TEXT(E2,"dd/mm/yy"),TEXT(F2,"dd/mm/yy)) > > I hope I can get the results looking better. > > That leaves me with the need to add the "conditional" element but LOOKUP > may be the solution as just by chance the elements /2 become 1,2,3,4 as > another subscriber has seen. > > On last question if I get it all worked out is how may I "freeze" the > formula results. I need to do this as I must remove a column used in the > formula before exporting as .csv for importation into an accounting > programme. > > Thanks for all your help so far. > Budgie > > > -- > 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 > -- 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
