MrExcel Publishing
Your One Stop for Excel Tips & Solutions

space delimited output from excel


Posted by Franz on February 13, 2001 3:42 AM

Please help,

I need to create a flat file output from excel, the *.prn file format works fine except that after 260 characters it does a line wrap!!!!

How can I get around this?


Posted by Mark W. on February 13, 2001 7:08 AM

Franz, have you considered saving in tab
delimited format and then stripping them off with
and editor? If you need a fixed format record
length you can change the worksheet's font to
a nonporportional font such as Courier and apply
cell formats to pad each cell with spaces. Cells
containing text should be formatted as "@* " and
cells containing numeric cells should be formatted
in a similiar fashion, but using their specific
numeric format (e.g., "* 0.00").

Note: the formats
listed above don't include the quotes. I included
them so you could see where a space was needed.