title: Is there a way to add leading/trailing spaces to item in concatenate function?
body: <p>I am trying to bring together several cells and they have a specific length so if I have</p>
  <pre><code>A1 needs to be 5 chars and the value is 'cat' 
  B1 needs to be 6 chars and the value is 'dog' 
  Concatenated it would be:
  [space space]cat[space space space]dog
  or
  &quot;  cat   dog&quot;
  </code></pre>
  <p>I'm having trouble finding a function or set of functions that allows this, most want to trim out leading or trailing spaces.</p>