Find/Replace Question

[JimS]

This happens almost everytime I use Find/Replace, but I just deal with
it. Maybe you guys can set me straight on this.

I have the following formula:

=SUMPRODUCT(--(MOD(ROW($AB$14:$AB$1008)-ROW($AB$14),4)=0),--(ISNUMBER($AB$14:$AB$1008)),--($AB$14:$AB$1008>0))

I want to replace all of the ABs with AK. So what I do is highlight
the formula, (Excel 2007) go to Home>Find and Select>Replace>
Find what: AB
Replace with: AK

Replace>Close

However, after I have done that I have to hit enter, and then I have
to hit UNDO to get the desired result.

There must be something simple I'm doing wrong. I use this feature
all the time, but it's frustrating having to go through this every
time.

Thanks in advance

 

[T. Valko]

I want to replace all of the ABs with AK.

So what I do is highlight the formula,
(Excel 2007) go to Home>Find and
Select>Replace>
Find what: AB
Replace with: AK
Replace>Close

Works OK for me in Excel 2207.

???

 

[JimS]

It's working fine for me too now. I don't know what changed, but all
off a sudden it started working correctly. But it reverts to this
periodically, and I have no idea why. Maybe I need to upgrade to
2207...

 

[T. Valko]

Maybe I need to upgrade to 2207...

You have to be on a special list to get Excel 2207!