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?

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