<div>
<div class="content wysiwyg-content">
in the last column of a spreadsheet.... &nbsp;the column holds one alphanumeric character or no character at all.<br />
My problem is when I save the excel file as a prn file, the last column in the prn file will contain the character if there is one, but if there is nothing in the cell, it puts nothing in the file for that column. &nbsp;the width is set to 1 and I have another column that is in the middle of the file and if there is no information in that cell, it exports the spaces determined by the width. &nbsp;The last column however, there is no space characters put in the prn file. &nbsp;I need excel to save one space in the prn file for the last column if there is no character data in the cell.<br />
how do I do this
</div>
</div>


in the last column of a spreadsheet....  the column holds one alphanumeric character or no character at all.
My problem is when I save the excel file as a prn file, the last column in the prn file will contain the character if there is one, but if there is nothing in the cell, it puts nothing in the file for that column.  the width is set to 1 and I have another column that is in the middle of the file and if there is no information in that cell, it exports the spaces determined by the width.  The last column however, there is no space characters put in the prn file.  I need excel to save one space in the prn file for the last column if there is no character data in the cell.
how do I do this

excel / adding a space to a prn file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.