I have an Excel worksheet with 24 fields which I need to create a flat file
to be read by another application. I need to fill any unused spaces in a
field with spaces so that when I have a field defined as five characters in
length, but the data in the worksheet has variable length data. I need to pad
the rest with blanks. This ensures that that a certain field starts in a
required column and is a certain length long. example: Last_Name 53,20, the
last name field begins in column 53 and is 20 characters in length.