I am importing a file into Excel. This Excel file will be read by an
automated system and needs to be formatted in a very precise way. Each field
from the data source (name, for example) is automatically inputed into a
column in Excel.

In order for the automated system to read this file, each column must be a
specific number of characters long, with blanks or zeroes making up the
difference. For example, if the name was "smith" and the "name" column is
supposed to be 40 characters long, the remaining 35 characters would have to
be accounted for somehow. I want the final product in Excel to be a text
string (no spaces, commas, columns, etc between each). I will be running
this report regularly, so the simpler the solution, the better.

Thanks!