Replace not giving expected results

[Hari]

Hi,

Facing a strange problem

I have sumproduct formulas in 96 cells.

The SumProduct criteria's are different for each cell except the last
criteria ---> ('Current all Emp. List'!$C$2:$C$7000=C$4).

Now, I want to remove this criteria from the formula as the base data Im
getting is already satisfying this criteria.

So I selected the 96 cells and presses Ctrl + H. In "Find what" I wrote
*('Current all Emp. List'!$G$2:$G$3500>$CA$5) and in "Replace with" I wrote
nothing , that is I left it blank.

I expected that when I presses ok in all cells which has the part *('Current
all Emp. List'!$G$2:$G$3500>$CA$5) the same will get expunged.

But to my horror nopes.

For a sample in BB6 I had this formula ->
=SUMPRODUCT(('Current all Emp. List'!$D$2:$D$3500=BB$4)*('Current all Emp.
List'!$E$2:$E$3500=$B$2)*('Current all Emp.
List'!$F$2:$F$3500=$B$1)*('Current all Emp.
List'!$G$2:$G$3500>TODAY()-30)*('Current all Emp. List'!$G$2:$G$3500>$CA$5))



Now, as explained above after doing Ctrl + H the result I got was --> ) -->
That is a single closing bracket . Why?


Regards,
Hari
India