You should try the "Formatted Text (Space delimited) (*.prn)" format. You
must adjust the worksheet column widths to the fixed field widths you want
before the file, save. Unless you use a fixed width font like Courier New
this (the column widths) may not look right in the worksheet, but the text
file should be okay.

--
Jim
"Paul from St.Paul" <Paul from wrote in
message ...
I want to create a file with fixed length records (lines). The fields
(columns) have defined lengths. When I export the file, it should be in a
flat text format, there should be no spacing between columns of data, and
the
total line length should be exactly what I want.

How do I do this? What format should I export the data into?