Jambruins,

If you have #NA in cells, there is likely a formula there that is producing
that error. If you delete these cells, you'll be deleting the formula,
whatever it is, that produced the NA error. Is that what you want?

You may be able to select them with Edit - Goto - Special. Select the
formulas button, and check only Errors. Again, be careful you're not
deleting formulas you need.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"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