Line lenght limit while saving as a PRN file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save as a .prn file 1
Working Around 240 Character PRN Field Width Limit 1
create fixed length cells & rows in excel as space delimited .prn 1
Problem with Saving Excel File as PRN 4
Saving a worksheet as . prn text file - record length 1
Converting excel to text file - Issue with wrapping text 7
How do I save a 689 character fixed field/record format file 1
how do i save an excel file as a non-delimited, non-packed fixed 1

Back
Top