Deleting #N/A from cells...

[Guest]

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

 

[Trevor Shuttleworth]

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

Regards

Trevor

 

[Guillermo]

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

 

[Earl Kiosterud]

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.