Microsoft Office Tutorials and References
In Depth Information
Using SEARCH or FIND to Locate Characters in a Particular Cell
Figure 11.59.
Figure 11.59.
LEN
LEN identifies the number of characters in a cell.
identifies the number of characters in a cell.
Using
Using
SEARCH
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.
