OK, this is what I can achieve with a simple text editor: Replace all "Rp" with "Rp|" Replace all " % " with "%" Replace all %) with )% Copy all and paste into a spreadsheet with English(UK) as import locale. Both, space and | as column delimiters with "Merge" option and "special numbers" option. This imports all dates, percents and currencies as correct numeric values.
-- 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
