Exporting to "prn" adding extra spaces with Excel 2003

[Guest]

When I export my work sheet to a "prn" format, it adds extar spaces to the
data. I did not notice this when I veiw the data in "Notepad" but when I
view the file using the "Edit" function in a DOS window, I can see the
spaces. I have been exporting to "prn" for 4 years now using Excel 2000 and
Excel 2002 with no problems. Does anyone know of a switch or toggle to
prevent Excel 2003 from adding the extra spaces when exporting to "prn".

 

[Myrna Larson]

That's the purpose of a PRN file. In a file of that type, columns are fixed
width, and data from every cell is padded with spaces (if necessary) to that
width.

Maybe in the past you exported to a text file, where a single tab character is
used to separate columns.

 

[Dave Peterson]

I like to change the font to Courier New and make sure the columnwidths are
correct, too.

I have a better chance of getting the text to line up where I want it.