Column search question - text vs. formulas

Okay, I just spent the better part of an hour beating my head against the keyboard with this issue. I have two columns - Column A is plain text, column B contains a formula such that the content is derived from this formula. Let's say it looks something like this:

column_a1_text column b1_text
column_a2_text column_b2_text

If I click the top of column B and search for "text", nothing is found. Column A search just fine. The only difference is as I've stated, column B is a "calculated" value. Why would Find and Replace care at all?

Originally Posted by chgilley

Why would Find and Replace care at all?

CTRL+H
expand "options"
"Look in:" change this to "Values" from default of "formulas"

Now find/replace will look for the cell output, instead of examining the formula in the cell.

Winon,

I'll give it a shot. FWIW, the answer was provided by Ben. What through me is that this optional box varies based on the content of the cell you are on. Just learned something new.

Thanks all.