View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StarRider StarRider is offline
external usenet poster
 
Posts: 2
Default How do I Delete Asterisks from contents in a cell of a column (kn.

I have an Excel Spreadsheet that I am trying to delete the Asterisks from.
The problem is that the asterisks are woven throughout the contents of a
cell. I do not want to delete those contents, just the asterisk. I usually
use "Find & Replace" to rid my cells of unwanted data, but an asterisk is a
wild card and find & replace does not recognize this character because of
it's wild card status. I deal with thousands of lines of data that I have to
manually edit currently. There must be a better way!!!Stumped in Denver