Click here to reset your password. You MUST have a valid e-mail address so that you may receive the instructions to complete the reset.

If this is your first visit, be sure to check out the Board FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.

I need to export a load of sheets for importing into an EDI system. I have tried with various text, tsv, csv files with various delimiters.
I can get each line of the sheet exported correctly but I actually need the whole file on a single continuous data stream (ie no line breaks)
There can be several hundred lines on the sheet.
I could happily put everything on a single line in the spreadsheet and then save as a csv however I doubt there are enough columns to support the size of the sheet
Does anyone know how to do this either with an export, macro/vba or even an external programme that takes my csv and converts the line breaks to commas