=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
|