Microsoft Office Tutorials and References
In Depth Information
FIND
Figure 12.3
The EXACT function tests
two sets of information
and displays a logical
value of TRUE or FALSE
depending on whether
the information is equal.
A
Used with cell
referencing
B
Used with the
OR function
FIN FIND locates one text string with another text string, and returns the number of the starting
position of find_text , from the leftmost character of within_text .
=FIND(find_text,within_text,start_num)
The FIND function locates one text string with another and returns the numeric position of
the text string.
The find_text is the text you want to locate or find.
FIND_TEXT
The within_text refers to the text string your looking within.
WITHIN_TEXT
The start_num refers to the number from left to right. For
example, Patrick where the “a” character would be 2 as the
start_num .
START_NUM
For example:
=FIND(“W”,”Wally Bill”) results in 1.
=FIND(“a”,”Wally Bill”) results in 2.
Search JabSto ::




Custom Search