Find/Replace Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

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
 
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
Click to expand...

Works OK for me in Excel 2207.

???
 
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...:-)
 
Back
Top