Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i save an excel file as a non-delimited, non-packed fixed | Excel Discussion (Misc queries) | |||
Create fields in a form with a fixed length | Excel Discussion (Misc queries) | |||
How do I export an Excel spreadsheet with fixed length rows? | Excel Discussion (Misc queries) | |||
Exporting from Excel to a Fixed Length Flat File | Excel Worksheet Functions | |||
Export file to CSV delimited with fixed field length | Excel Discussion (Misc queries) |