Add Number of Spaces to String Using a Formula

[turtlepokerman]

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 concatenate function? If the Fruit Type is in cell A1 and the Quantity is in cell B1. The number of spaces will be shown in cell C1. The output should show the complete text in cell D1.

All help is appreciated.

 

[turtlepokerman]

[SOLVED] Add Number of Spaces to String Using a Formula

Figured it out.

I need to use the REPT() Function

=REPT(" ",numbers of times to repeat)

 

[dcardno]

You don't need to show the number of spaces separately (although you can, if you otherwise have a need for it). The REPT function (why not "REPEAT" I have no idea) will do it for you:

=A1 & REPT(" ",max(0, 9 - LEN(A1) - LEN(B1))) & TEXT(B1,"#")

You might want to increase the total length of the strings, to allow for, say, pineapple

 

[gaz_chops]

Try

=A1&REPT(" ",9-(LEN(A1)+LEN(B1)))&B1