Microsoft Office Tutorials and References
In Depth Information
Using SEARCH or FIND to Locate Characters in a Particular Cell
Figure 11.60.
Figure 11.60. When the manager asked an employee to type this in Excel, she
When the manager asked an employee to type this in Excel, she
didn t realize that the employee had never used Excel before.
didn t realize that the employee had never used Excel before.
Note
Like all the other data sets in this topic, these names and addresses
are randomly generated from lists of the most popular first name,
last name, street name, and city names. Don t try to send Christmas
cards to these people, because none of the addresses exist. And don t
think that the ZIP Codes are real; everything here is completely ran-
dom.
Here is how to make this work properly:
11. To find all the customers in California, in cell B2, enter =FIND(",
=FIND(",
CA",A2). When you enter the formula, you get a #VALUE! error. This is
okay. In fact, it is useful information: It tells you that CA is not
found in the first record.
22. Copy the formula down to all rows.
33. Sort low to high by column B. You ll see that 98% of the records
have a #VALUE! error and sort to the bottom of the list. The few Cali-
CA",A2)
Search JabSto ::




Custom Search