First, apology for the late reply Second a thought directed at me by me 'be careful what you wish for' Third, thanks Rémy
Rémy your understanding of spreadsheets is obviously a great deal deeper than mine, your solution does what i want. :) i just have to work out what its doing now, I've never seen the 'SUBSTITUTE' function before, going to be fun working out whats going on, i can feel a headache coming on already again thanks ----- IGraham W1064 LibreOffice 5.1.6.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203p4199622.html Sent from the Users mailing list archive at Nabble.com. -- 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
