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...