View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jwarner8 jwarner8 is offline
external usenet poster
 
Posts: 1
Default create fixed length cells & rows in excel as space delimited .prn

Need fixed length cells and rows in excel spreadsheet saved as space
delimited .prn file. The .prn file will be FTP'd to Mainframe computer file
(which has fixed length fields (each cell = a field in Mfrm file) in a fixed
length record. Is there a way to format cells as text data, with a fixed
number of spaces in the cell? Then the client could overtype the spaces with
the required data.