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

  • Thread starter Thread starter Parag
  • Start date Start date
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?
 
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...
 
Back
Top