Format cells with Space in excel

[hesam bahrani]

Hi
How to Choose the format my cells, such as (For Example in D1)

=LEFT(D1&REPT(" ",15),15)

For more:

"hesam&10space"
"Ronaldo&8space"
"Ronaldinho&5space"

Thanks for your help!

 

[Fluff]

How about
=A5&REPT(" ",15-LEN(A5))

 

[Scott Huish]

How did this not work for you?
=LEFT(D1&REPT(" ",15),15)

 

[hesam bahrani]

How about
=A5&REPT(" ",15-LEN(A5))

thank you
But I mean the Number format

 

[Scott Huish]

You can fill out a cell with a character in a number format, but you can't put a specific differing amount with a number format based on length of the string

@*

Put a space after the asterisk.

 

[hesam bahrani]

You can fill out a cell with a character in a number format, but you can't put a specific differing amount with a number format based on length of the string

@*

Put a space after the asterisk.

thank you!
For me, the number * is important (15 * )

 

[Scott Huish]

Then you need to use a formula or VBA.

 

[hesam bahrani]

Then you need to use a formula or VBA.

I need the format
no VBA

 

[Scott Huish]

There is no format that will do that. Even if there were, the cells would not actually contain the characters, it's just a format.

Use the formula.
Copy down.
Copy and Paste Special Values onto your original data.
Delete the column with the formulas.

 

[hesam bahrani]

There is no format that will do that. Even if there were, the cells would not actually contain the characters, it's just a format.

Thank you very much