Anybody know how to generate an ascii file from Excel in a fixed position fomat, as distinct from CSV format ? I want each column to have a specific no. of characters,e.g. Col 1 to be 12 characters, col2 to be 6 characters, col3 to be 12 characters etc.
Right click Column 1 and specify the column width as 12 characters, etc, etc. Then save the file with Formatted text (Space delimited) (*.prn) as the file type. Seems to work.....