| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed length text file
Is it possible to create a fixed length text file from an Excel file? Thanks!
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed length text file
Eric
Set the columns to the character width of the fixed width column, e.g 30 for 30 characters. (even if the data is partly hidden or there seems a lot of room in the cell) Now save the file as a 'formatted text (Space Delimited)'. That should do it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Eric" wrote in message ... Is it possible to create a fixed length text file from an Excel file? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Improrting Text file to a matrix when things are not constant. | Excel Worksheet Functions | |||
| Can I use Excel to create this text file? | Excel Worksheet Functions | |||
| Exporting excel to text file | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
