No. separation

[mahmoud-lee]

The same problem
The problem appears when the number is equal to two digits
Thank you very much
Excellent thinking
Sorry,for the effort

[Ingolf]

The same problem
The problem appears when the number is equal to two digits
Thank you very much
Excellent thinking
Sorry,for the effort

I do not know what you want ...

@Admin
In your formula this part REPT("-",$C$1-LEN($A3)) will be always #value cause this $C$1-LEN($A3) will be a negative number.