Replacing leading zeros with space

[kralimarko]

I want to replace leading zeros with space,

0000064646877,26 - " 64646877,26
0005069000322,17 - " 5069000322,17

 

[kralimarko]

Sorry with spaces, how many zeros, that many spaces

 

[ChrisOswald]

Assuming there's always exactly 1 comma and that the "stuff" in front of the comma is numerical, this formula should do the trick

=REPT(" ",LEN(A2) - LEN(1*LEFT(A2,FIND(",",A2)-1) & RIGHT(A2,LEN(A2)-FIND(",",A2)+1)))  & 1*LEFT(A2,FIND(",",A2)-1) & RIGHT(A2,LEN(A2)-FIND(",",A2)+1)

 

[shg]

If the comma is your decimal is your decimal separator, then

=RIGHT(REPT(" ", LEN(A9)) & TEXT(A9, "General"), LEN(A9))

 

[gothic chicken]

I want to replace leading zeros with space,
0000064646877,26 - " 64646877,26
0005069000322,17 - " 5069000322,17

Assuming the comma is your decimal separator rather than a period, this formula should work for either separator: =REPT(" ",LEN(A1)-LEN(--A1))&--A1