View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Langschied David Langschied is offline
external usenet poster
 
Posts: 7
Default Fill in Text with blanks.

I am completing a requirement for a bank upload of account transactions.
There is a requirement that the upload contain blanks to the right to fill a
required field. I am struggling to figure out how to do this.

Example:
If the field is 18 characters long and the entry is 10 characters long, then
they want the remaining characters expressed as blanks to the right.

So,

HowdyDoody would be "HowdyDoody "


Any ideas?