If you'd rather not reformat your worksheet to accommodate the png
format, you can use VBA to export fixed field formats:

http://www.mcgimpsey.com/excel/textf...tml#fixedfield


In article ,
"Paul from St.Paul" wrote:

Thanks for your replys, Jim and Earl,

The part I was missing was the Formatted Text (Space delimited) export
format. I am planning to use the Data Validation Text length tool to make
sure each field is the right length, and I will use Courier New font.

Paul