Microsoft Office Tutorials and References
In Depth Information
Using SEARCH or FIND to Locate Characters in a Particular Cell
fornia records have a valid result for the formula in column B and
sort to the top of the list, as shown in Figure 11.61 .
Figure 11.61.
Figure 11.61. You don t care where
found the text; you simply want to
divide the list into records with valid values versus errors.
You don t care where FIND
FIND found the text; you simply want to
divide the list into records with valid values versus errors.
Caution
The trick with this application of FIND is to look for something that
is likely to be found only in California records. If you had custom-
ers in Cairo, Illinois, they would have also been found by the FIND
command you just used. The theory with this sort of search is that
you can quickly check through the few matching records to find false
positives.
FIND and SEARCH are similar to one another. The FIND function does not dis-
tinguish between uppercase and lowercase letters. FIND identifies CA, ca, Ca,
and cA as matches for CA. If you need to find a cell with exactly AbCdEf,
you need to use the SEARCH command instead of FIND. Also, SEARCH allows
for wildcard characters in find_text. A question mark (?) finds a single char-
acter, and an asterisk (*) finds any number of characters.
Search JabSto ::




Custom Search