concatenate spaces

  1. T

    Add Number of Spaces to String Using a Formula

    Hello, I am trying to create a formula that adds spaces so that the string equals a certain number of characters. Orange_12 (x1 spaces) Apple__13 (x2 spaces) Jam____14 (x4 spaces) *Where underscore represents a space Is there anyway that I could multiply a quantity of spaces with the...
  2. L

    CONCATENATE with spaces

    Hi Can some one please tell me if it is possible to concatenate with spaces? I have information (names) to pull from two cells into one but when i use CONCATENATE it adds both together and leaves no space. Am i using the wrong formula? :eeek:

Some videos you may like

This Week's Hot Topics