View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
confused confused is offline
external usenet poster
 
Posts: 193
Default Deleting specific text using VBA ?

I have a spreadsheet that contains over 6,000 lines and 20 columns. The
spreadsheet changes often. Each of these columns may have "0", "-", "0.00%",
"call desk" etc. Instead of manually recording the macros to delete these
specific values for each column, is there a code to do this?