Line lenght limit while saving as a PRN file
 

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

Line lenght limit while saving as a PRN file
 

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

Patrick wrote:

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

Line lenght limit while saving as a PRN file
 

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

"Bob I" wrote:

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

Patrick wrote:

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

Line lenght limit while saving as a PRN file
 

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

On Oct 26, 8:43 pm, Patrick wrote:
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



"Bob I" wrote:
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

Patrick wrote:

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 - Hide quoted text -

- Show quoted text -

Line lenght limit while saving as a PRN file
 

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

Patrick wrote:

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

"Bob I" wrote:


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

Patrick wrote:


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