Deleting #N/A from cells...
 

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

=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

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

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