removing interior spaces
I don't know.
Adam wrote:
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
--
Dave Peterson
|