Thread: View code for removal of unwanted text in cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
  
Posts: 460
Default View code for removal of unwanted text in cells
How can I make a cell blank when it has a certain phrase such as #DIV/0! or
N/A. I have a lot of these and it would be much better without them. I
prefer a blank cell. Any ideas out there?
--

Reply With QuoteReply With Quote