Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 22nd 05, 10:15 PM
Jambruins
 
Posts: n/a
Default 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   Report Post  
Old February 22nd 05, 10:31 PM
Trevor Shuttleworth
 
Posts: n/a
Default

=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   Report Post  
Old February 22nd 05, 10:36 PM
Guillermo
 
Posts: n/a
Default

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   Report Post  
Old February 23rd 05, 12:36 AM
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting rows with blank cells Batman Excel Worksheet Functions 10 February 16th 05 07:01 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 16th 05 12:14 AM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 02:15 AM


All times are GMT +1. The time now is 02:48 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017