View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fancode fancode is offline
external usenet poster
 
Posts: 1
Default delete hyphens within a cell while maintaining the data therein

I have a series of numbers to paste onto a sheet that have hyphens in them
and the end user of the sheet wants them omitted (the hyphens), but I can't
seem to replace them with blank spaces. I tried Find/Replace, but was only
succesful on one occasion and I can't seem to duplicate that success. Thanks.