View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smartgal smartgal is offline
external usenet poster
 
Posts: 84
Default Finding (and eliminating) hidden "space" character

I downloaded some numeric data but I have discovered that there is a leading
"space" character. I tried a find and replace and a host of other tricks but
short of going into each cell and deleting I'm at a loss for how to bulk find
and replace this. It's preventing me from sorting, etc. I tried to outfox
it by doing a formula and adding the value to "0" but I got an error and when
I asked it to evaluate it gave me the following:( =" 1069.95"+0) and that's
how I discovered the leading space.

Thanks -

mm