Thread: removing interior spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
  
Posts: 287
Default removing interior spaces
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??
Reply With QuoteReply With Quote