| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
save an excel file in fixed length records whose fields are blank
I need to save the data in ascii format including fields that are fixed
length and have spaces in them. I have tried every save as type. Each column is formatted to the column width of that field (10cpi). For example a last name may be smith but that field is 15 characters long.Excel puts either a space or tab between fields but does not retain the spaces. please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
| File close excel does not ask me to save changes | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
| How can I batch open a txt file in excel 2003 and save back as a . | Excel Discussion (Misc queries) | |||
| In Excel: If I know a file has 147,000 records, but Excel will on. | Excel Discussion (Misc queries) | |||
Threaded Mode
