Hello all,
I am having an issue of special formats making lookups fail. On 2 excel
sheets with data I need to merge, via lookup, both have multiple corrections
on them. The problem lies in this, the corrections are done by using the
"Strike out" feature, which causes errors in the lookup. Is there any way,
or special syntax I cna use, possibly in the find and replace menu, to find
ALL data with strike outs and remove them?
Thanks
Dave B.