Our old legacy financial system requires fixed width columns, separated by commas, in the text files used for updating product prices. In Lotus there is a print to file option which pads out the columns with spaces and inserts a comma between the fields.

I know all about the Save as .csv and .txt options in Excel and even found the "Formatted Text (space delimited) *.prn" option. This option sounds the same as the Lotus option and it adds the extra spaces required, but it does not insert the commas to delimit the fields.

Am I missing something? Can anyone help, please?