View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
davids davids is offline
external usenet poster
 
Posts: 10
Default Blank Characters in data

sorry just to clarify its as if blank characters overlap actual letters so
you have to manually hit backspace over a letter to make the space disappear.
hope this makes sense :P

"davids" wrote:

I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?