Need to make txt sheet with specific fields taking up a specific number of spaces.

Hello hello! I have data I ultimately need to be in a .txt file that is sent over FTP to a database. Each space counts, and each field has a specific amount of spaces that need to be there before the next field is entered. There is software to correctly do this, but it has no option of importing files to pull data from, all the data has to be manually typed in. Right now I use a keyboard and mouse macro to copy and paste data from my excel sheet to the software, but would like to have excel just go ahead and write the data file for me.

Here is a link to the description of what the requirements are:

http://www.myfloridalicense.com/dbpr...uctions_09.pdf

it is on pg 16

Each table and spaces talked about within are 1 line. The next table is the next line down.