"bearie" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to Export from Excel to a Fixed Length Flat File?
File > Save As... > Save as type: Formatted Text (Space delimited)
(*.prn)
Caution:
- insufficient column width leads to truncated cell content
- only the active worksheet is saved.
Make all columns wide enough and you are safe!
Bookmarks