Find All function looping in Excel 2010

I'm using Excel 2010 with Windows 7. I tried to do a "Find All" for formulas and for values, on a value which I know appears somewhere in two of the cells. Here's what happened:

I clicked Ctrl+F, entered the text in the box, clicked on "Find All", with Options By Sheet, By Rows, Formulas. (I also tried by Values.)
Excel started repeatedly searching cells A1 thru S45 (the Last Cell). Each time it got to the first of the two cells containing the searched text, it listed this "found" cell again, and then searched again from A1 thru S45, and never got out of the loop. When I clicked Esc, it indicated "108,457 cell(s) found"; of course, that was the self-same cell 108,457 times! It never found the second one at all.

I tried starting Excel in Safe Mode, and got the same problem.

Anyone have a clue to how to fix this issue? Thanks!

Try find instead of find all and step through them to see what it's finding.

Thanks. It exists twice in the worksheet. It finds it first in a merged cell which runs from Q19 thru Q24, then it finds it repeatedly in N23 and never gets back to the merged cell. If I do a FindAll and abort it, it lists

Q19
N23
N23
N23
N23
etc.

Thanks.

Click in a blank cell, e.g. A26. In the Find box, do By Sheet, By Rows, By Formula. Don't check "Match case" or "Match entire cell contents." Enter party in the search box, and click on Find All. When it starts looping, click Esc button.

Thanks, tigeravatar. That worked. This was not a problem with Office 2003, so I'm surprised Microsoft left this problem there in 2010, without ever issuing a fix for it. It's unfortunate that we cannot reliably use the Merge Cells function.