excel to text with column format

Hello,

I have a excel file that I would like to convert it to a text file with some formatting to it's columns. Please see the attached file for the data.

This is the format for the text file.

Id 9 chars
6 filler characters (let's say #)
last name - 17 chars
first name - 17 chars
middle name - 1 char
6 filler chars
Address1 - 35 chars
1 filler char
Address2 - 35 chars
1 filler char
City - 15 chars
1 filler char
State - 2 chars
1 filler char
zipcode - 5 chars
13 filler chars

How do achieve this format?
Thank you everyone...

Hello Xtro,

Here is a sample of the output from a macro I wrote. Is this close to the output you want?

Please Login or Register  to view this content.

Hello Xtro,

Here is the macro code. The macro has already been added to the attached workbook. You will need to change the file path and name to what you are using. It is marked in red. If the file already exists, any data will be overwritten. If it doesn't exist, the macro will create it.

Please Login or Register  to view this content.