Discussion Locked

Excel to ASCII Fixed Field Carrage

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to create an ASCII, Fixed Field, Carrage Return/Line Feed record delimited file.

I know it is possible but can not seem to get the righe "Save as File" option.

This should be straight forward but, I am at a loss to find the solution.

3 replies

by dklippert

Set your column widths to the number of characters required. Use File, Save As
to save the worksheet and, in the "Save as type" dropdown, choose "Formatted text (Space delimited)(*.prn)". This will create an ASCII file with the required number of characters per column.

This discussion is closed to new replies.