View Single Post
  #3   Report Post  
Guillermo
 
Posts: n/a
Default

one way, still kinda manual, but faster than what you are doing now:
select your range
data/filter/autofilter.
select #N/A
now all the #N/A are easy to erase as a group
data/filter/autofilter


"Jambruins" wrote in message
...
I have values in cells C1-C162. However, some of the cells have #N/A in
them. Is there a quicker/better way to delete them all from the cells
instead of highlighting them all and deleting them? Thanks