Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows with blank cells | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |