removing interior spaces

[Adam]

I have some data, like this

090308 4213
090308 4213
090308 4213
090308 4214

that have interior spaces and I need them removed without removing the
leading zero, I have tried "find replace" and that removes the leading zero.
Any ideas??

 

[Dave Peterson]

Can you use a helper cell?

=substitute(a1," ","")

 

[Adam]

is there a third party addin that works as well

Can you use a helper cell?

=substitute(a1," ","")

 

[Dave Peterson]

I don't know.

is there a third party addin that works as well