Need to convert from Excel to text file fixed width, space delimited other than .prn

[zmiles]

I have an Excel file that I need to convert to a fixed width, space delimited text file, however when I tried converting to a .prn file it is wrapping the columns that exceed 240 characters per line.

It has to text file with padded spaces or fixed width columns.

What other format can I use?

Any assistance much appreciated.

 

[pgc01]

Hi

pnr files have this 240 character limit.

A solution id to write some vba code to write directly to the file.