| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't filter/clean cells that contain #NAME?
My list has some data like,
=2 = XX Naturally this results to the error #NAME?. So I tried to clean this using filter -- find/replace. But.. it won't filter. So I thought copied the values as plain-text to another column, then used... =IF(F2911="#NAME?",CONCATENATE("'",F2911),F2911) so I can add ' to all such values. Unfortunately, that doesn't work eithee.. . Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't filter/clean cells that contain #NAME?
Maybe you can use:
=if(iserror(f2911), .... On 03/15/2011 19:27, Parag wrote: My list has some data like, =2 = XX Naturally this results to the error #NAME?. So I tried to clean this using filter -- find/replace. But.. it won't filter. So I thought copied the values as plain-text to another column, then used... =IF(F2911="#NAME?",CONCATENATE("'",F2911),F2911) so I can add ' to all such values. Unfortunately, that doesn't work eithee.. . Any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to clean empty cells | Excel Discussion (Misc queries) | |||
| How do I remove border lines around cells; I want to clean up the | New Users to Excel | |||
| How can I get =Clean and =Proper Case to run on all cells in a col | Excel Worksheet Functions | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Linear Mode
