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
|