Can't filter/clean cells that contain #NAME?

P

Parag

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?
 
D

Dave Peterson

Maybe you can use:

=if(iserror(f2911), ....



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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
On Double Click - Filter Transactions to New WorkSheet 0
Drop down list control value in vba 2
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Data Validation & Filtering Lists 3
Macro to clean inconsistent data 0
Weird Behaviour of Compiler Directives? 14
Filtering arrays 8

Top