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!

 

[Rick Rothstein]

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

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

I am not sure exactly what your question is, but the above formula works fine for me when placed in a cell.

 

[hesam bahrani]

I am not sure exactly what your question is, but the above formula works fine for me when placed in a cell.

Hello Mr. Rick
For me, this formula also responds to the cell, but I mean the cells format, which apparently does not

Anyway thank you