Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a "fixed-width" datafile?
I need to create a fixed-width file from an Excel .xls file to import into my
FedEx shipping software. How may I save or convert my file into a fixed field datafile? Thanks in advance, Alex |
#2
|
|||
|
|||
If you don't have too long a line (no more than 240 characters per line), try
saving a copy of your workbook as a .prn file. Look in the Save As Type box: Formatted Text (Space delimited)(*.prn) I like to change to Courier New font and resize the columns the way I like. Alex K wrote: I need to create a fixed-width file from an Excel .xls file to import into my FedEx shipping software. How may I save or convert my file into a fixed field datafile? Thanks in advance, Alex -- Dave Peterson |
#3
|
|||
|
|||
Dave,
Thank you for responding. I do need to save the file as a "fixed field". the .prn option saves it as a "space" delimited file. Know how to get it into a "fixed field" format? I have about 30 columns of data with 2-35 characters per cell. And about 2000 rows. Thanks again, Alex "Dave Peterson" wrote: If you don't have too long a line (no more than 240 characters per line), try saving a copy of your workbook as a .prn file. Look in the Save As Type box: Formatted Text (Space delimited)(*.prn) I like to change to Courier New font and resize the columns the way I like. Alex K wrote: I need to create a fixed-width file from an Excel .xls file to import into my FedEx shipping software. How may I save or convert my file into a fixed field datafile? Thanks in advance, Alex -- Dave Peterson |
#4
|
|||
|
|||
Actually, it doesn't save the file as space delimited (each field separated by a
single space). It's fixed width. The number of rows don't matter--but the number of characters per line will. Another option is to have a macro do it for you. JE McGimpsey has some nice code you can borrow and enhance at: http://www.mcgimpsey.com/excel/textfiles.html Alex K wrote: Dave, Thank you for responding. I do need to save the file as a "fixed field". the .prn option saves it as a "space" delimited file. Know how to get it into a "fixed field" format? I have about 30 columns of data with 2-35 characters per cell. And about 2000 rows. Thanks again, Alex "Dave Peterson" wrote: If you don't have too long a line (no more than 240 characters per line), try saving a copy of your workbook as a .prn file. Look in the Save As Type box: Formatted Text (Space delimited)(*.prn) I like to change to Courier New font and resize the columns the way I like. Alex K wrote: I need to create a fixed-width file from an Excel .xls file to import into my FedEx shipping software. How may I save or convert my file into a fixed field datafile? Thanks in advance, Alex -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
fixed column width with text string | Excel Discussion (Misc queries) | |||
Export to fixed width text file | Excel Discussion (Misc queries) |