is there a third party addin that works as well

"Dave Peterson" wrote:

Can you use a helper cell?

=substitute(a1," ","")



Adam wrote:

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