Delete extra spaces and adding 2 zero number

[muhammad susanto]

hello all,

i need formula to delete extra spaces and adding/insert zero number (00) in between,
my text/string is 12 digits number

for example :

sample	expected result
2006 10 2801	200610002801
2003 08 0074	200308000074
etc

<tbody>
</tbody>

thanks for your help....

 

[Rick Rothstein]

hello all,

i need formula to delete extra spaces and adding/insert zero number (00) in between,
my text/string is 12 digits number

for example :

sample	expected result
2006 10 2801	200610002801
2003 08 0074	200308000074
etc

<tbody>
</tbody>

thanks for your help....

This formula looks like it does what you want...

=REPLACE(SUBSTITUTE(A1," ",""),7,0,"00")

 

[muhammad susanto]

Thanks...rick..

It's very help full for me..........