Export to fixed width text file

I need to export an Excel spreadsheet to a fixed width text file--it cannot
be tab- or comma-delimited. I've found that Access can do this correctly for
me and will let me control the export process. However, my problem is that
my company does not support Access so I have to find another method of
exporting, and about the only tool I have available is Excel. No matter what
I seem to do, it saves it in a tab-delimited format.

To try and force it as a fixed width file, I change the font to Courier New,
then I save it as a MS-DOS .txt file. Can someone suggest something that may
help?

Are you saving it as Fixed Format (.prn) format?


"FinChase" <[email protected]> wrote in message
news:[email protected]...
: I need to export an Excel spreadsheet to a fixed width text file--it cannot
: be tab- or comma-delimited. I've found that Access can do this correctly for
: me and will let me control the export process. However, my problem is that
: my company does not support Access so I have to find another method of
: exporting, and about the only tool I have available is Excel. No matter what
: I seem to do, it saves it in a tab-delimited format.
:
: To try and force it as a fixed width file, I change the font to Courier New,
: then I save it as a MS-DOS .txt file. Can someone suggest something that may
: help?

Save it as Formatted Text, space delimited (.prn)

Be sure to set the font to fixed width and adjust the column widths correctly.

On Mon, 24 Jan 2005 10:47:04 -0800, "FinChase"
<[email protected]> wrote:

>I need to export an Excel spreadsheet to a fixed width text file--it cannot
>be tab- or comma-delimited. I've found that Access can do this correctly for
>me and will let me control the export process. However, my problem is that
>my company does not support Access so I have to find another method of
>exporting, and about the only tool I have available is Excel. No matter what
>I seem to do, it saves it in a tab-delimited format.
>
>To try and force it as a fixed width file, I change the font to Courier New,
>then I save it as a MS-DOS .txt file. Can someone suggest something that may
>help?

Thanks to all who replied. I was able to use the suggestions to get export
working properly.

"Myrna Larson" wrote:

> Save it as Formatted Text, space delimited (.prn)
>
> Be sure to set the font to fixed width and adjust the column widths correctly.
>
> On Mon, 24 Jan 2005 10:47:04 -0800, "FinChase"
> <[email protected]> wrote:
>
> >I need to export an Excel spreadsheet to a fixed width text file--it cannot
> >be tab- or comma-delimited. I've found that Access can do this correctly for
> >me and will let me control the export process. However, my problem is that
> >my company does not support Access so I have to find another method of
> >exporting, and about the only tool I have available is Excel. No matter what
> >I seem to do, it saves it in a tab-delimited format.
> >
> >To try and force it as a fixed width file, I change the font to Courier New,
> >then I save it as a MS-DOS .txt file. Can someone suggest something that may
> >help?
>
>