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