how to save fixed format text file

[Don K.]

I have an Excel file which is 269 characters wide. I need
to save this file in fixed format but experience line wrap
when using the PRN file type.

Anyone have an answer to my problem?

 

[Jim Rech]

You might have to use a macro to get the result you want. See if Chip
Pearson's text export macro does it:

http://www.cpearson.com/excel/imptext.htm

 

[Dave Peterson]

You have a few choices (try against a copy of your worksheet):

I'd either concatenate the cell values into another column:

=LEFT(A1&REPT(" ",20),20) & LEFT(B1&REPT(" ",10),10) & TEXT(C1,"000,000.00")

Then I'd copy and paste to notepad and save from there. Once I figured out that
ugly formula, I kept it and just unhide that column when I wanted to export the
data.

If that doesn't work for you, maybe you could do it with a macro.

Here's a link that provides a macro:
http://google.com/[email protected]