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?