Using Control+F (Find ) function in Excel 2000 (9.0.3821 SR-1)

[jbusalachi]

Excel does not return certain data. I can manually go in and find it, very
that I input the search data correctly, but Control+F (find) will not pick it
up.

 

[hgrove]

jbusalachi wrote...

Excel does not return certain data. I can manually go in and
find it, very that I input the search data correctly, but Control+F
(find) will not pick it up.

What exactly are you looking for? Excel's Edit > Find command provide
so-called wildcards to allow some fuzziness in searches. * matches an
number of characters, and ? matches any single character. To fin
literal * and ?, you need to precede them with ~, so to find ~ you als
need to precede it with ~. So, e.g., to find FOO~BAR in some range, you
search pattern would need to be FOO~~BAR