Re: How do I create a "fixed-width" datafile?
- From: "Earl Kiosterud" <nothanks@xxxxxxxxxx>
- Date: Mon, 20 Jun 2005 08:46:12 -0400
I think Dave's solution is what you need. There's a section on fixed-length
text files at http://www.smokeylake.com/excel/textfiles.htm that may help.
"Alex K" <Alex K@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> 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,
> "Dave Peterson" wrote:
>> If you don't have too long a line (no more than 240 characters per line),
>> 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
>> 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
- Prev by Date: Re: Use of variable to identify range of sheets in a workbook
- Next by Date: How do I throw in an ISERROR function on a complicated VVLOOKUP?
- Previous by thread: Re: How do I create a "fixed-width" datafile?
- Next by thread: SUMIF Alternative?