View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
alish alish is offline
external usenet poster
 
Posts: 25
Default Remove Data from Empty Cells

Hi all,
How do i remove data from the cells that have been pasted as value? The
cells were originally formulas but i have copy-special-value pasted. some of
them are blank but when i do COUNT it counts. how do i remove or clear-all
hundreds of cells at once? there are also cells with the info among them.
Please help. Thanks.