Hello,

We send data to another company as a comma separated txt file. Now I am
being told to switch to the fixed length format (*.txt) instead of the comma
separated format (*.csv).

I am not sure how to go about this. Any suggestions are greatly welcomed.

I am starting with a plain excel export from access. And, I have been given
fixed character lengths to apply. Other postings here suggest using the
Courier New font (which is fixed-width - all characters), then setting the
column widths for the character count in each column. Then use Save As with
the prn file type.

How do you set the character count? Do you use Conditional Formatting or
Data Validation? And if so how can you tell if this has been applied?

Then how do you convert the prn file to *txt?