Line lenght limit while saving as a PRN file

[Guest]

Hi,

Anyone's aware of any problem regarding a maximum number of character per
line when saving an excel spreadsheet as a PRN file. We currently have an
excel sheet that has way over 250 characters in length but when saving as a
PRN and then re-open the file in notepad(or even Word), it is being cut at
234 characters.

Thanks

 

[Bob I]

Why save as prn? There is not a problem with PRN character lenght, it
just has a 240 character line lenght specification.

Formatted text (.prn) is limited to 240 characters per line in Excel
http://support.microsoft.com/kb/249885

 

[Guest]

Unless you have an alternate way to save an excel file as text and respect
the width of each columns, which the dedicated and only way to do this(as far
as I know) is to save as PRN

 

[Pete_UK]

You can use a non-proportional font like Courier and adjust the column
widths as required and then save as a .txt file.

Hope this helps.

Pete

 

[Bob I]

Then you may have to reduce the character count, or pad with spaces and
save as csv.