View Single Post
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

=IF(ISNA(your_formula),"",your_formula)

Regards

Trevor


"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