Microsoft Office Tutorials and References
In Depth Information
Using SEARCH or FIND to Locate Characters in a Particular Cell
Figure 11.59. LEN
LEN identifies the number of characters in a cell.
identifies the number of characters in a cell.
SEARCH oor FIND
FIND to Locate Characters in a Particular Cell
to Locate Characters in a Particular Cell
Two nearly identical functions can scan through a text cell, looking for a
particular character or word. Many times, you just want to know if the word
appears in the text. These functions go further than telling you if the char-
acter exists in the text; they tell you at exactly which character position
the character or word is found. The character position can be useful in sub-
sequent formulas with LEFT, RIGHT, or REPLACE.
First, let ’ s look at an example of using FIND to determine whether a word
exists in another cell. Figure 11.60 shows a database of customers. The
database was created by someone who doesn ’ t know Excel and jammed every
field into a single cell.